Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I have a problem with a DAX measure that does not behave as I am expecting. I want to highlight the current month users are reporting for, but it seems that "LASTROWNONBLANK" does not work for that. It might be due to the fact that the column is of a string type, because if I use the number of the month (7 = July), it works fine. Does anyone know the rootcause of this problem or can suggest an alternative measure?
Thanks!
Try Sorting Text column (month name) by Month Number and hope this problem may be sorted
Proud to be a Super User!
I already have that setting, unfortunately it doesn't generate the desired outcome but I solved it by using IF statements. Thanks!
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |