Forum Discussion

joc's avatar
joc
Icon for Helper I rankHelper I
9 years ago
Solved

Add new rows and new column with calculated values

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

  • 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,

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    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,