PowerbI challenge: Multiple GroupBy in PowerBI. How to do it?

[Anonymous]

Hi,

I have below table where I am trying to do grouping of columns based on their months( which is same in different rows) so that I can have 12 unique rows of different months with their value summarized. I am able to do group by in one column but then its fetches me a new table and I am not able to do groupiing on other columns.

For example: Below table have Actual and Planned date.

• I need to sum up YTD values based on Actual Date and
• sum up Initial FC value based on Planned Date.

All these in one table so that the result will be Planned Date and Actual Date having rows from Jan- Dec and their corresponding YTD and FC values summed up.

• For months which are not there they can return 0 value.

Hope I am clear and guys out there can help me in figuring this out

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Based on my understanding, you want to sum YTD based on Actual Date month and sum Initial FC based on Planned Date month, display those two new columns in one table based on months, right?

In your scenario, you can duplicate a new query to get a new table named Test(2) from the original table (Test), and create a new column month in each table. Then calculate total for YTD based on Actual Date month in Test(2), and total for Initial FC based on Planned Date month in Test. Finally merge those two tables. For details, you can download attached pbix file.

Best Regards,
Qiuyun Yu