Forum Discussion
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 with the measure I have written which are shown in below. Can you please help to look into and advise how I can modify the Measure in order to achieve what I want?
I have also shared the Excel file and PBI file with the link at the bottom.
Measure
Matrix Table
Raw Data
Account Mapping
https://drive.google.com/drive/folders/1XTp2ajb8ZnncG1YqdgvMIxfXfedQKdIe?usp=drive_link
lbendlin Awesome!! Thanks a lot!
4 Replies
access denied. Where in your raw data do you indicate the expected sort order of your categories?
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
PBI Link
https://drive.google.com/file/d/1M6_Ue3A0aCJ_1yR4vXijeXfVAktt-Gri/view?usp=sharing
