Forum Discussion
admin11
Memorable Member
Memorable MemberProblem Statement 3 on GL Analysis :- Sort P&L Field in Sequences
Hi All https://www.dropbox.com/s/nk4gj83c50jjg7m/PBT%20GL%20VER0029%20GL%20ANALYSIS%20PROBLEM%20STATEMENT%20V001.pbix?dl=0 Above my PBI file Paul
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
PhilipTreacy
Super User
Super UserOK, 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
admin11Memorable Member
Memorable Member