Forum Discussion
Solved
Measure Help
Hi there; I need your little help, I have a table like as below I need to calculate with a measure only the sum of the amount of the current month and previous month For the below example , as y...
erhan_79
Try below measure:Measure = CALCULATE( SUM(Table1[Amount]), FILTER( ALL(Table1[Date]) , Table1[Date] <= EOMONTH(TODAY(),0) ) )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
erhan_79
Try below measure:
Measure =
CALCULATE(
SUM(Table1[Amount]),
FILTER( ALL(Table1[Date]) ,
Table1[Date] <= EOMONTH(TODAY(),0)
)
)________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
