3 Ways to Add Leading Zeros to Numbers in Power Query
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 …
Pivot Text Values in Power Query – Explained
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 …
Replace Values in Power Query M (Ultimate Guide)
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 …
How to create a Journal Entry with Power Query
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 …
Understanding Evaluation Context in DAX
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 …
5 ways to Calculate Last 12 Months in DAX for Power BI
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 …
Using Group by to Concatenate Text in Power Query
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 …
How to use Conditional Formatting based on a Measure in Power BI
With conditional formatting in Power BI, you can apply formatting to your values based on conditions. For example, you can format a cell’s background based …
Optimizing the performance of DISTINCTCOUNT in DAX
A common operation in Power BI is calculating the Distinct Count of a column. You may, for example, want to show the number of unique …
Mastering IF Statements in Power Query – Including Nested IF-Statements
The IF function in Power Query is one of the most popular functions. It allows you to make comparisons between a value and what you’re …
