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 …
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 …
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 …
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 …
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 …
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 …
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 …