I’ve written about a method to dynamically flatten parent-child-hierarchies also with multiple parents some while ago here. I’ve actually used this approach for Bill-of-materials cases and refined that approach in (…) Read more
Posts in Category ‘Data Modelling’
Compare Power BI files with Power BI Comparer tool
Have you ever wanted to compare a version of a Power BI file with a previous one? … In the unlikely case that you haven’t yet, just wait until the (…) Read more
Date.DatesBetween to retrieve dates between 2 dates in Power BI and Power Query
Today I’m sharing a handy function with you that allows you to retrieve all or just a couple of dates between 2 given dates: Date.DatesBetween. Usage This function takes 3 (…) Read more
Right Aligning Text in Power BI: Format Improvements for Easy Profit&Loss Reports
Edit 14-Dec-2017: Now that we can right-align text measures in PowerBI, a SWITCH-measure like here: http://www.thebiccountant.com/2017/04/24/kpis-in-easy-profit-and-loss-for-powerbi/#comment-719 is the best alternative in my eyes. No need to read on 🙂 As (…) Read more
How to open a complex JSON record in Power BI and Power Query
Today I’ll show you a very useful technique how to deal with a JSON record that contains a wild mixture of different elements like this: If you click on one (…) Read more
Bill of Material (BOM) Explosion Part2: Costing in Excel and PowerBI
Following up on the BOM-explosion: A comment reminded me that I had missed to present the costing techniques to calculate the total costs of each (sub)-product. Reversing the aggregation direction What (…) Read more