This post describes how to create a dynamic date table using Power Query. Virtually every Power BI solution benefits from a date table. The date …
Read moreCreate the Ultimate Date Table in Power Query (incl Script)
In this post you learn how to get the previous row value using Power Query. This is a useful skill to compare previous row value …
You have a report and want to show a default slicer value that moves with time. When you arrive at the next month, you want …
Read moreSet Default Slicer Value to Current Month in Power BI
A leading zero is any 0 you add before the first nonzero digit of a string. By definition, these are invisible when a value has …
Read more3 Ways to Add Leading Zero to Number in Power Query
The above video breaks down how you can pivot text values in Power Query. The regular pivoting of numbers is straight forward. But when text …
Replacing values is a common transformation for cleaning data. Power Query allows you to easily replace values using the user interface. Yet, this is often …
Create a journal entry using Power Query. In this post you learn how to create records, sum columns and combine datasets using Power Query. A …
The most important concept to understand DAX is evaluation context. This context is used when evaluating calculations to get the result. Some of your calculations …
It is common in financial reports to calculate the last 12 months in DAX. With it Power BI does a rolling 12 months calculation from …
Read more5 ways to Calculate Last 12 Months in DAX for Power BI
Most users know the Group By functionality in Power Query. It allows you to summarize data and aggregate the grouped values. The standard aggregations are …
Read moreAggregate Text Values Using Group By in Power Query | Concatenate Grouped Values
