Help with Financial Layout

[H_insight]

Hello,

I am combining multiple tables, and I want to reflect the same financial layout in power bi. I tried building a custom map in excel to load in PQ, but not sure if it works. any help is greatly appreciated.

The sample file looks like the below:

Sample data

@Vijay_A_Verma  Any chance you can help please?

[H_insight]

Many thanks for the prompt response @Vijay_A_Verma 👍

The expected Outcome is:

[Vijay_A_Verma]

What values to populate in these rows - Total Performance, Total Customer, Total Risk, Total Priorities, Total Summary

Will these be blanks?

[H_insight]

@Vijay_A_Verma Today I got the usual email from Microsoft to say "Did you get the answer you needed?". Do you have any updates? if you can't help, no problem and thanks for your time. In the end, this is a voluntarily help, but it's good to set expectations.

[H_insight]

Hi @Vijay_A_Verma , Do you need any additional information from my side?

[H_insight]

Values should be the total of Parents like below:

If that is extra work, please ignore it.

[Vijay_A_Verma]

What is the layout of output expected?

[H_insight]

@Vijay_A_Verma Would it be easier if I upload the expected outcome in excel?

Here is the file