Big issue with Totalling column

[Anonymous]

Hello everyone,

I want to properly structure my data in Power BI and I can't manage to come up with a solution.

I got this table named PL that looks like in the photo below, I'm using it to show some amount values for a profit & loss report in Power BI.

I want to use it to structure the data in a hierarchical way let's say like this

The records in the table are of 2 types, TOTAL and STANDARD, all the TOTAL records reference other records from the table ( including other totals.. that's a big problem for me ) in the Totalling column.

I tried duplicating the table but I'm stuck..

Did anyone ever faced this issue?

Thanks for your time!

[v-deddai1-msft]

Hi @Anonymous ,

Would you please show us sample pbix file? I'm not getting clear from your description without sample data.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai