Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, i want to create a measure show the sum of invoices from the latest month, my data set is several months out of date so i need to look for the latest month of data in the data set, fairly confident i need to use the MAX function but can't quite work out how to include it in the measure, thank you!
Solved! Go to Solution.
Hi @Anonymous ,
try this measure, maybe it works, but if you can share some sample data of your table it is better.
CALCULATE(
SUM('Table'[Amount]),
'Table'[Month] = MAX('Table'[Month])
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
try this measure, maybe it works, but if you can share some sample data of your table it is better.
CALCULATE(
SUM('Table'[Amount]),
'Table'[Month] = MAX('Table'[Month])
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |