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, I would like to use DAX measurement to Display the Latest Total Value with reference to the time.
If I use Max, the value will only show 625, but i want it to display 600 as thats the latest updated value
Please help
Solved! Go to Solution.
Hi @YingRui ,
See below,
Let me know if you have any questions. I used a test in there so we didn't get zero.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Latest time Total = var LateTime = CALCULATE(Max('Table'[Time]),'Table'[Completed]>0) var LatestValue = CALCULATE(MAX('Table'[Total]),'Table'[Time]=LateTime) return LatestValue
Proud to be a Super User!
Hi @YingRui ,
See below,
Let me know if you have any questions. I used a test in there so we didn't get zero.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Latest time Total = var LateTime = CALCULATE(Max('Table'[Time]),'Table'[Completed]>0) var LatestValue = CALCULATE(MAX('Table'[Total]),'Table'[Time]=LateTime) return LatestValue
Proud to be a Super User!
Thankyou @Nathaniel_C
I changed the 'Table'[Completed] to 'Table[Total]
and i was able to achieve the total line when the last updated time was 9am
@Nathaniel_C wrote:Hi @YingRui ,
See below,
Let me know if you have any questions. I used a test in there so we didn't get zero.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Latest time Total = var LateTime = CALCULATE(Max('Table'[Time]),'Table'[Completed]>0) var LatestValue = CALCULATE(MAX('Table'[Total]),'Table'[Time]=LateTime) return LatestValue
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 |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |