Forum Discussion

BHarm65's avatar
BHarm65
Frequent Visitor
2 years ago
Solved

Calculate sum over previous years

Hi,   I have a question about a date calculation. I have a report that needs to calculate the values of fixed assets.   The reports need to display the selected year for certain columns and for ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi BHarm65 ,

     

    I made simple samples and you can check the results below:

    You just need to add conditions to the fiter according to your needs.

     

    Measure = var _select= SELECTEDVALUE(DimDate[Year])
return SUMX(FILTER('Table',[Date].[Year]<_select),[Value])

     

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

BHarm65's avatar
BHarm65
Frequent Visitor
2 years ago

So extra information.

I tried the DAX function SAMEPERIODLASTYEAR but this only will give me the previous year and not all the years before the selected year.

I need to calculate the value from 2018 unit the selected year.