Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
6 years ago
Solved

Grgouping groups

I need to group groups and calculate only last group values to not dublicate each parents total sums, as each parent group have total sum of their child. for exmpla group 1 have total of 11+12+16, 11...
Need Help
Tips and Tricks
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi Analitika ,

     

    Sorry for that we cannot use the Power Query Editor in your PBIX.

    So we create a sample, and you can refer the following steps to create the hierarchy.

     

    1. Merge the current table.

     

     

    2. Expand the sas_kod column.

     

     

    3. Then merge the current table again.

     

     

    4. Expand the change type sas_kod.

     

     

    5. Add two columns.

     

     

     

     

    6. At last we can create a matrix table using this table.

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

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

     

    BTW, pbix as attached.

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
6 years ago

Hi Analitika ,

 

Sorry for that we cannot use the Power Query Editor in your PBIX.

So we create a sample, and you can refer the following steps to create the hierarchy.

 

1. Merge the current table.

 

 

2. Expand the sas_kod column.

 

 

3. Then merge the current table again.

 

 

4. Expand the change type sas_kod.

 

 

5. Add two columns.

 

 

 

 

6. At last we can create a matrix table using this table.

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

 

Best regards,

 

Community Support Team _ zhenbw

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

 

BTW, pbix as attached.