Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Calculated column in matrix

Hi ,   How to create dynamic calulated(Total) Column in matrix by using the names.   For example i have two names like ABC , DEF and in future the new name will add say GHI with values. Now i ne...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi rsaprano,

Thank you for your reply.

 

It is an unpivoted data. Can you please explain in detail.

 

Regards,

Suresh pantra.

rsaprano's avatar
rsaprano
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

Here is a link to a PBIX that has  your sample data in there with the unpivot example applied in the query editor as i was suggesting (along with the matrix)...if you edit source and add a new column to the table it will be picked up automatically.

 

 

Here is an animated gif that shows how to apply the steps.

 

If this answers your query, please mark the answer as accepted!

 

Thanks

 

Rishi