Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query
In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure…
Archive
Tag: PowerPivot
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…
Quick Tips: Keyboard Shortcuts/Hotkeys When Writing DAX in Power BI Desktop
Keyboard shortcuts is an interesting topic for developes that can really improve your report development in Power BI Desktop. In…
Using “IN” Operator in DAX
If you are a SQL guy I bet you’ve used “IN” operator zillions of times. You might also looked for…