Marco Russo has created a great tool for SSAS tabular that lets you edit measure definitions (which you should read here first if you haven’t done yet). In this article (…) Read more
All Posts by Admin
Incremental load in PowerBI
Edit 2017-Jan-13: You’ll find a more recent version that doesn’t use hacks for incremental load here (but that also won’t work in the service): http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ If you want to perform (…) Read more
Speed up the PowerBI and Power Query design process
When querying large databases with Power BI or Power Query, the design of the query itself sometimes causes long waiting periods because of background loading activities. In order to speed up (…) Read more
How to tame Case Sensitivity in Power Query and PowerBI
Have you heard of “Comparer.OrdinalIgnoreCase”? If the answer is “No” (or something similar), you will be very delighted to hear that this is your key to disable case sensitivity in comparing operations. (…) Read more
Easy Profit and Loss and other (account) scheme reports in Power BI and Power Pivot using DAX
This is about an easy way to create typical finance reports like Profit and Loss using DAX that (unlike all other solutions I’ve come across so far) can be handled with (…) Read more
Advanced type detection in Power BI and Power Query: Table.ClassifyMixedColumnTypes
This is not a proper blogpost, just a quick share of a function I’ve created today which I think will be very useful for others as well: Automatic type detection will (…) Read more