Forum Discussion
Memorable MemberProblem Statement 3 on GL Analysis :- Sort P&L Field in Sequences
OK, because your table was created with DAX I had to modify this code to add the SortOrder column when the table was created
VAR tbl = {(t_rev, 1), (t_cogs, 2), (t_oth, 3) , (t_exp, 4)}So now you can set the SortOrder in Model view for REV&COGS - I've already done it in the attached PBIX file.
Regards
Phil
Super UserHi Paul,
Sorry, slight modification here.
In Power Query create a new column called SortOrder in the table with this code
if [REV&COGS] = "REV" then 1 else if [REV&COGS] = "COGS" then 2 else if [REV&COGS] = "OTH" then 3 else 4
Which gives you this in the Data Model when you Close & Apply
Then in the Model view click on the REV&COGS column and set the Sort by Column to SortOrder
Regards
Phil
Memorable Memberthank you very much , i have add the expression for Sort , also set sort at model table , but the table still not yet sort.
Below my PBI file :-
I get error when i try to sort :-
Paul
- PhilipTreacy
Hi Paul,
Sorry I made a mistake in the initial answer. Check above for the correction.
regards
Phil
- admin11
Hi Phil
Very sorry , now i get more error.
Can you pls share with me the PBI file.
Paul Yeo
- PhilipTreacy
OK, because your table was created with DAX I had to modify this code to add the SortOrder column when the table was created
VAR tbl = {(t_rev, 1), (t_cogs, 2), (t_oth, 3) , (t_exp, 4)}So now you can set the SortOrder in Model view for REV&COGS - I've already done it in the attached PBIX file.
Regards
Phil