Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Start date

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 an...
Need Help
Show and Tell
  • selimovd's avatar
    selimovd
    4 years ago

    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
     

selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

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