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…
Archive
Category: Power BI Desktop RS
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: 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…
Good Practices: Always Display the Reporting Environment
When you work on real-world projects in power BI, you would probably have different environments Like DEV, UAT, Pre-Prod and…