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 and the last date should be dynamic to today.
 
Any idea
 
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
     

1 Reply

  • 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