Forum Discussion

kelvin-lkhca's avatar
kelvin-lkhca
Icon for Helper I rankHelper I
2 years ago
Solved

PNL by Account

Hi All,   I have created a measure and wish to achieve the something like illustrated below with the measure and matrix table,         However, I can't get the same result as above table ...
Need Help
kelvin-lkhca's avatar
kelvin-lkhca
Icon for Helper I rankHelper I
2 years ago

Hi lbendlin ,

Sorry that forgot to change the access restriction previously. Please find below for the link.

 

Yes, there is one table in the PBI, shown as below, is used to sort the order of the categories.

 

 

 

 

Folder link

https://drive.google.com/drive/folders/1XTp2ajb8ZnncG1YqdgvMIxfXfedQKdIe?usp=sharing

 

Sample Data link

https://docs.google.com/spreadsheets/d/1s8CZ_6VxIsI69qJP5yxow17i1t4MlCgb/edit?usp=sharing&ouid=110570727743616034194&rtpof=true&sd=true

 

PBI Link

https://drive.google.com/file/d/1M6_Ue3A0aCJ_1yR4vXijeXfVAktt-Gri/view?usp=sharing

  • kelvin-lkhca's avatar
    kelvin-lkhca
    Icon for Helper I rankHelper I
    2 years ago

    lbendlin  Awesome!! Thanks a lot!