Forum Discussion

Fabi's avatar
Fabi
Frequent Visitor
3 years ago
Solved

Cumul with filter date

Hi all !   I have a report like this : I would like that, when I select a year in the filter, it sums the selected year and all the previous years. Exemple : if I select 2021 in the filter,...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

     

    Expected measure: =
CALCULATE ( SUM ( Data[Value] ), 'Year'[Year] <= MAX ( 'Year'[Year] ) )

     

Fabi's avatar
Fabi
Frequent Visitor
3 years ago

Thanks FreemanZ  and Jihwan_Kim ,

 

The solution of Jihwan_Kim work simply.

 

In my real data, I was working with a date field and it didn't work. I had to extract in another column the year and use this one for it to work.

 

Thanks !