Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
5 years ago
Solved

Perform Measure on Matrix Values

I have a dataset similar to... Person 1 Active Person 2 Active Person 3   Person 4 Active Person 5   Person 6     The a Matrix Visual similar to... Person 1 Active ...
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi StuartSmith ,

     

    Please refer to my .pbix file.

    Note: First copy and paste the table data(2), then unpivot columns '4G', '5G', 'Esim', 'Porting', then you can get table 'date(3)'.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.