Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm currently trying to get the last value in each column to be displayed via the following measure:
Week Number | Sum of Daily Totals |
41 | 19438 |
42 | 11117 |
43 | 11145 |
44 | 9134 |
However when I run this formula I get the second last value 11145 and not the last 9134 which is the one I need, does anyone know how to do this?
Thanks in advance
Solved! Go to Solution.
You need to use LASTNONBLANKVALUE. Please try this measure expression in a card visual, replacing Daily for your actual table name.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Niiru1 , Try like
Latest Sum of Daily Totals = LASTNONBLANKVALUE(pg14[Week Number],CALCULATE(SUM('pg14'[Sum of Daily totals])))
You need to use LASTNONBLANKVALUE. Please try this measure expression in a card visual, replacing Daily for your actual table name.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |