Finding Minimum Date and Maximum Date Across All Tables in Power Query in Power BI and Excel
When we talk about data analysis in Power BI, creating a Date table is inevitable. There are different methods to create a Date table…
Quick Tips, Power BI Desktop, Query Parameters, Part 4, Passing Power Query Parameter Values to SQL Server Stored Procedures
I have written 3 blogposts about query parameters in the past. Power BI Desktop Query Parameters, Part 1, Introduction Power…
Quick Tips: Converting Hexadecimal, Oct and Binary to Decimal in a Single Power Query Function
A while ago I wrote a blogpost on how to use Unicode characters in Power BI. In that blogpost I…
Quick Tips: Time Dimension with Time Bands at Seconds Granularity in Power BI and SSAS Tabular
I wrote some other posts on this topic in the past, you can find them here and here. In the…