Posts from:Blog, PowerBI
Power BI – DAX If Statements
By: David Rohlfs Introduction Getting into Microsoft Power BI can be a little daunting at times. There are coding languages, data models, custom fields, and so much more. But the best way to take on the learning process is by learning the basics then... (more...)
Power BI – DAX ABS Function
By: David Rohlfs Introduction If you are not new to DAX, then you know that there are some functions that can save you a lot of time if you can remember to use them. One of these functions is the Absolute Value (ABS) function. What this function does... (more...)
Power BI – Fuzzy Match Maximum Number of Matches
By: David Rohlfs Introduction If you have worked with fuzzy match before, you know that there are a lot of complexities to how you can create your merge. One of the most useful of these is the Maximum Number of Matches option. This feature allows you... (more...)
Power BI – Fuzzy Match Similarity Threshold
By: David Rohlfs Introduction When you are working in Power Query, there are a lot of times where you need to merge queries together and the data might not have perfectly matching key columns. When this happens you probably turn to fuzzy matching. But... (more...)
Power BI – Fuzzy Match Transformation Table
By: David Rohlfs Introduction When you start working with Power Query there are a lot of difficulties, and one of the harder ones is working with combining, merging, and appending data. Using a Fuzzy Match can be helpful but there are some advanced options... (more...)
Power BI – M Code If Statement
By: David Rohlfs Introduction When you start getting into M Code in the Power Query, you find that you need to know a few things sooner than later. Some of these are adding new columns, creating variables, and utilizing If statements. If statements... (more...)
Power BI – Difference Between Count and Count Distinct
BY: David Rohlfs Introduction When you begin to learn about data and reporting, there can always be some vocabulary that is difficult to recognize. For a lot of people this can be realizing the differences between a Count and a Count Distinct. In this... (more...)
Power BI – DAX Calculate Function
BY: David Rohlfs Introduction When you work in Microsoft Power BI, there is a constant need for growth in your DAX and M Code knowledge. But it can be hard to know where to start. For DAX, one of the best places to start is with the Calculate function.... (more...)
Power BI – Field Parameters
BY: David Rohlfs Introduction If you are familiar with parameters, then you might’ve heard of a Field Parameter. Field parameters are parameters that contain entire fields of values, and they have some interesting properties. As of writing this blog,... (more...)
Power BI – Utilizing a Group By Function
BY: David Rohlfs Introduction When you grow in your report building skills there are some processes that you begin to use more and more often. One of these processes for me is How I use the group by function to create a new column. This is a process... (more...)