TOTALYTD several years extension

Question

Hello,

I am looking for to use a function to aggregate a stock value but on a time period that goes on several years. To have the total value for each date I can use TOTALYTD but there is a limitation when I switch years. Is it possible to extend this type of function to evaluate the stock each day (with new entries and new outs) on several years?

For example, for the material 10396025, The stock from december is not displayed as I wish it would.

Thanks for your help

Answer 1

This is a DAX question and this is a Power Query forum. You can write a custom time intelligence function like this

Total Lifetime ToDate =
CALCULATE(sum(table[value]),FILTER(ALL(Calendar),Calendar[date] <= max(Calendar[date])))