I need your help on this measure.
Cumul Liquido = CALCULATE( [Líquido (Mvm)], FILTER( ALLSELECTED( ‘Tab Dates’), ‘Tab Dates’[Date] <= MAX( ‘Tab Dates’[Date] )))
My visual is a matrix by account number, no columns. The purpose is to have a measure for 2019 and another for 2020, and another 2 for the diff, abs and %.
I also have a filter by month. It’s suppose to show cumulative values for that month, i mean, if i select Mar, i will have the total for Jan, Feb and Mar.
This measure above works for a particular month but not for cumulative values till that specific month.
Can you help?
Thanks a lot