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
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
Super UserHi 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
- admin11