accumulated to fixed date

Hello I have the date of the last order that has come in. I want to know the accumulated for this period in different years and put it on a card. For example, if the last date is 02/15/2022, I would...

Mikelytics

Resident Rockstar

3 years ago

Hi Syndicate_Admin

Please check the following formula

TOTALYTD-Funktion (DAX) - DAX | Microsoft Learn

In the first argument you put in the expression like SUM(Table[Column]) and in the second the list of dates like Table[Dates]. You should work with a sepaarte date table which is linked to your fact table.

Best regards

Michael

-----------------------------------------------------

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

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

Syndicate_Admin
Administrator
3 years ago
Thank you. I had already tried it but when selecting the year 2021 it gives me the accumulated to 12/31/21, when what I wanted is the accumulated to 2/15/21.
Best regards
Aureli

Forum Discussion

accumulated to fixed date