December 2, 2024 Rick de Groot Power Query 12 Create Date Table or Calendar in Power Query M This post describes how to create a dynamic date table using ... Read more
November 17, 2023 Rick de Groot Power Query 18 Get Value from Previous Row using Power Query In this post, you learn how to get the previous row ... Read more
August 18, 2024 Rick de Groot Power BI 12 Set Default Slicer Value to Current Month in Power BI You have a report and want to show a default slicer ... Read more
November 17, 2023 Rick de Groot Power Query 13 3 Ways to Add Leading Zeros to Numbers in Power Query A leading zero is any 0 you add before the first ... Read more
February 23, 2024 Rick de Groot Power Query 1 Pivot Text Values in Power Query – Explained The above video breaks down how you can pivot text values ... Read more
August 18, 2024 Rick de Groot Power Query 75 Replace Values in Power Query M (Ultimate Guide) Replacing values is a common transformation for cleaning data. Power Query ... Read more
November 17, 2023 Rick de Groot Power Query 2 Manually Insert Rows to a Table in Power Query There are situations where you may manually want to add rows ... Read more
November 17, 2023 Rick de Groot DAX 1 Understanding Evaluation Context in DAX The most important concept to understand DAX is Evaluation Context. This ... Read more
November 17, 2023 Rick de Groot DAX 11 5 ways to Calculate Last 12 Months in DAX for Power BI It is common in financial reports to calculate the last 12 ... Read more
February 26, 2024 Rick de Groot Power Query 56 Concatenate Text with Group By (Combine Rows) in Power Query In this post, you learn how to group your data and ... Read more
November 17, 2023 Rick de Groot Power BI 5 Apply Conditional Formatting based on a Measure in Power BI With conditional formatting in Power BI, you can apply formatting to ... Read more
November 17, 2023 Rick de Groot DAX 11 Optimizing the Performance of DISTINCTCOUNT in DAX A common operation in Power BI is calculating the Distinct Count ... Read more
