Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
23 | |
15 | |
15 | |
10 | |
7 |