Forum Discussion

Uma_Dhandpani's avatar
7 years ago

How to combine only particular column

Hi,

I have attached the sample data. I required the percentage of report as together comparing with the year-wise report

Having data as thisRequired as this

1 Reply

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support

    Hi Uma_Dhandpani ,

     

    You can add a new calculated column to calculate the diffenrences of percentage and use this new column in the visual. 

    Your sample data is like a matrix that is complex for PowerBI to handle. I think a table is better if you can get it.