Posts from:Blog, PowerBI
Power BI – DAX Running Totals
By: David Rohlfs Introduction I recently came across a problem where the end user wanted to see data that was 3 weeks before today and three weeks after as a running total. Naturally, I took on the problem and found myself thinking about all the possibilities... (more...)
Power BI – Creating a Report from an Existing Semantic Model
By: David Rohlfs Introduction As I use Microsoft Power BI more and more, I notice that creating one master semantic model becomes important when working within a department. Fortunately, there is a very easy way to use an existing semantic model that... (more...)
Power BI – Today in DAX and M Code
By: David Rohlfs Introduction Have you ever been working with dates in DAX or M Code and realized that you weren’t sure how to reference today’s date as a dynamic date? This seems to be a common issue among newer Microsoft Power BI users because of... (more...)
Power BI – DAX Selected Value
By: David Rohlfs Introduction Have you ever wanted to have more control and dynamic ability over your DAX? Using the Selected Value function in DAX allows you to do this very well. When you use the Selected Value function, you are able to read the data... (more...)
Power BI – All and AllExcept in DAX
By: David Rohlfs Introduction There are a lot of times when working with DAX where your equations and calculations just don’t work. This happens especially when you start working with dates and times. One of my favorite solutions to fixing DAX equations... (more...)
Power BI – Replace Values in Power Query
By: David Rohlfs Introduction There are a lot of reasons why your incoming data will be wrong. It could be because of the system that inputs the data, the person who is adding data to the server, the server itself, or the way that you imported the data.... (more...)
Power BI – Modulo and Integer-Divide Function
By: David Rohlfs Introduction Often when you are working with Power BI you start working with complex code and transformations in the Power Query. And you often do this so much that you forget some of the basic aggregations and transformations. In a previous... (more...)
Power BI – Index Function in Power Query
By: David Rohlfs Introduction One of the most important aspects of a semantic model is having the Row Specific Column. This is a column that is specific to a row of data and is used to build relationships to other tables or queries. But what if your data... (more...)
Power BI – Group By Index
By: David Rohlfs Introduction Recently I have come across a problem where I needed to have an index column that restarted for each separate category. It turns out that there isn’t a built-in way you can do this without creating multiple queries. But... (more...)
Power BI – Group By All Rows
By: David Rohlfs Introduction When you are trying to clean your data, there are always obstacles and challenges. And because of this it is important to learn different methods of how to work with your data. If you clicked on this blog, you probably already... (more...)