Forum Discussion
Matrix Table - Target Value
Hi Team, I have Matrix table and need to add Target value in the last column, I don't have idea, Can you help me. This is Matrix Table , need to add Target last column but it show's each we...
Hi Anonymous ,
I've done this in the past but this is a bit finnicky and a little advanced I would say. I made use of a disconnected table and additional tweakings in Power Query. Using a dummy data, this is the closest I could getThis is the link to the PBIX for your reference: https://drive.google.com/file/d/1O9SBD3efHRF608lyl7uaxQ2Ad0R3i_Qa/view?usp=sharing
AllisonKennedy
Community Champion
Community ChampionAnonymous This is difficult with a matrix. You would need to create a measure for every Week, as well as a measure for every target, and add each to the matrix. You could also potentially create a Measure table using SWITCH and SUMMARIZECOLUMNS functions.