Posts from:Blog, PowerBI
Power BI – Remove Duplicates From Multiple Columns
BY: David Rohlfs Introduction For many reports, duplicates will need to be removed from data because it can cause your calculations to be incorrect. But there are also a lot of instances where it can be hard to determine what fields you need to... (more...)
Power BI – Initials from a Name (First Letters from String of Text)
BY: David Rohlfs Introduction I recently ran across a problem where I needed to have the initials of someone’s name and all that I had was a column with their full name. Because of this I wanted to write a blog about how to get the first letter... (more...)
Power BI – Adding A Custom Column
BY: David Rohlfs Introduction When you work in Power BI you never have everything that you need. It is very common to need to add your own column and learning to do so can be difficult at first. There is a lot of knowledge that you need to learn before... (more...)
Power BI – Extract Function
BY: David Rohlfs Introduction When you are learning how to use Microsoft Power BI and Power Query, learning about all the different features can be exhausting. So, there are a couple of features that you should learn earlier than others and the Extract... (more...)
Power BI – Split Column
BY: David Rohlfs Introduction There are a lot of reasons why you would need to split a column. Whether you are just trying to separate a section of text from another, or you need to separate two sets of numbers. Splitting a column quickly becomes a must... (more...)
Power BI – Arithmetic in Power Query
BY: David Rohlfs Introduction For many people that are used to Power BI, we tend to see a lot of functions and know what most of them do, but we only use a couple of them. One set of these functions that I tend to rarely use are the Arithmetic based functions... (more...)
Power BI – Using Shape Maps, KML files, and Zip Code Lists in Microsoft Power BI
BY: David Rohlfs Introduction Not too long ago I ran across a request to create a shape file that could integrate into Microsoft Power BI, and of course this opened a rabbit hole of questions and opportunities. Because of the discoveries while... (more...)
Power BI – Updating a Power BI Report to the Service
BY: David Rohlfs Introduction When you start working with a new program or software there is always a learning curve and Power BI is no different. Something that can be hard to figure out if you do not have any knowledge of what is going on is how you... (more...)
Power BI – Power Query M Code Basics
BY: David Rohlfs Introduction In this blog we are going to focus on the basics of M Code in Power Query. You can either access Power Query in Microsoft Excel or I will be doing this blog in Microsoft Power BI. For the purposes of this blog there will... (more...)
Power BI: Clear all Slicers
BY: David Rohlfs Introduction Recently there was the addition of the Apple All Slicers button in Power BI and with it another button that can be used to Clear All Slicers. This clear all slicers button can simplify the end user difficulty of making sure... (more...)