Forum Discussion

Dharmeshs's avatar
Dharmeshs
New Member
4 years ago

Need calculated column in Matrix table

Hi,

 

I created one matrix table in Power BI,

I need to add one more calculated column where I can use the formula

as i have Below is the screenshot where I Need to Bring % column calculation basis on  (Total Actnet/ Total QuoNet) 

 

Need Help

1 Reply

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    4 years ago

    Hi Dharmeshs ,

    %Ach =ActNet/QuoNet?

    In my opinion, create a calculation table and then merge the calculation table with the original table, depending on your actual situation, can you provide the Pbix file for me to test.Remember to remove confidential data.

     

     

    Best Regards

    Lucien