Add new rows and new column with calculated values

[joc]

Hello everybody,

I have a problem to add new rows and a column with conditions.

I have this table :

And I would like this table :

Thanks a lot for the help,

Joc

[v-sihou-msft · Accepted solution]

@joc

Either DAX or Power Query can not insert rows into existing dataset. In your scenario, you should directly create a measure instead of inserting rows for the aggregated data.

Regards,