Forum Discussion
Using an account-based data model in Power BI
I would like to migrate an account-based data model (from SAP Analytics Cloud) to Power BI. Essentially, all key figures are kept in its own dimension, which contains calculated key figures, hierarc...
I think ImkeF , should able to help on this.
But you might have be very specific about information you need. Also refer :https://radacad.com/build-your-first-star-schema-model-in-action-power-bi-modeling-basics
Thanks, all helpful information, however, star schema is also not the problem. You are right, I should be more specific - and I already asked specific questions in this forum. Such issues like handling of exception aggregations, ragged hierarchies, ragged aggregation formulas, etc.. Bit this topic was just to check if someone else has ever tried this and has some more general modelling tipps.
I think we can close this.
Hi
I've blogged a bit about these things here:
- https://www.thebiccountant.com/2019/10/03/parent-child-hierarchies-with-multiple-parents-in-power-bi-with-power-query/
- https://www.thebiccountant.com/2016/07/21/easy-profit-loss-account-scheme-reports-power-bi-power-pivot-dax/
- https://www.thebiccountant.com/2017/05/08/dynamic-bill-of-material-bom-solution-in-excel-and-powerbi/
- A nice implementation for the typical P&L-problems (mixture of running totals and group totals) with DAX can be found here: https://www.managility.co/profit-loss-dynamic-sub-totals-in-power-bi-excel-dax/
