Set Default Slicer Value to Current Month in Power BI
You have a report and want to show a default slicer value that moves … Read more
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 … Read more
Pivot Text Values in Power Query – Explained
The above video breaks down how you can pivot text values in Power Query. … Read more
Replace Values in Power Query M (Ultimate Guide)
Replacing values is a common transformation for cleaning data. Power Query allows you to … Read more
How to Create a Journal Entry with Power Query
Create a journal entry using Power Query. In this post you learn how to … Read more
Understanding Evaluation Context in DAX
The most important concept to understand DAX is Evaluation Context. This context is used … Read more
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. … Read more
Using Group by to Concatenate Text in Power Query
In this post you learn how to group your data and concatenate text values. … Read more
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 … Read more
Optimizing the performance of DISTINCTCOUNT in DAX
A common operation in Power BI is calculating the Distinct Count of a column. … Read more
Receive the latest article in your mailbox