Forum Discussion
Using an account-based data model in Power BI
dp32 ,
You can refer to doc below to learn how to build a report in power bi desktop.
https://docs.microsoft.com/en-us/power-bi/desktop-what-is-desktop
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, but I am not a beginner in Power BI, I have already build quite some models.
This is really a question to the experts, how to translate an account-based data model.
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/
