Start date

[Anonymous]

Hello Team,

I need help to calculate sales with a specific start date.

I need something like that:

Sum(Append1[Sales])

I created a calendar.

My start date should be 01/06/2022 and the last date should be dynamic to today.

Any idea

[selimovd · Accepted solution]

Hey @Anonymous ,

you can change the filter context with the CALCULATE function.

The following approach should work:

Sales since January 6 2022 =
CALCULATE (
    SUM ( Append1[Sales] ),
    'Date'[Date] >= dt"2022-01-06" && 'Date'[Date] <= TODAY ()
)

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic