Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I have a default table visual and I need to by dault sort by two column. Date and Amount, 1st Latest Date then if date is same again sort by Largest Amount.
For Example
Debtor / Amount / Order Date
A/10000/31.12.2022
B/1000/06.10.2022
M/5000/31.12.2022
Output Require
Debtor / Amount / Order Date
A/10000/31.12.2022
M/5000/31.12.2022
B/1000/06.10.2022
Please suggest
Solved! Go to Solution.
Hi,
In the Table visual, use th shift key to sort by multiple columns.
Simple enough
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi,
In the Table visual, use th shift key to sort by multiple columns.
An evident limitation is all selected columns are sorted in either asending or descending order only.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi,
It should be automatic when user opening the report (default view)
So what happens when you try my solution? Does the sorting not stay as is when you open the file?
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |