Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |