Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Week to Date Sales

I've created a measure to show the week to date sales but it keeps showing the whole year the measure is as follows

 

Sales CWeek = CALCULATE([Total Demand Orders], FILTER(Monthly, YEAR((Monthly[Report Date] = YEAR(NOW()) && WEEKNUM(Monthly[Report Date],2) = WEEKNUM(NOW(),2)))))
 
But it keeps displaying the full year any help please.
Alane
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Anonymous ,

     

    Create below measure:

    Current WTD Sales = CALCULATE(sum(Sales[Sales]),WEEKNUM(Sales[Created Date])=WEEKNUM(TODAY()))

     

    Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!

  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    Anonymous 

     

    What is the [Total Demand Orders] measure?

     

    I have tested a variation of your measure and it delivers the value for this week. See:

     

2 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ,

     

    Create below measure:

    Current WTD Sales = CALCULATE(sum(Sales[Sales]),WEEKNUM(Sales[Created Date])=WEEKNUM(TODAY()))

     

    Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

     

    What is the [Total Demand Orders] measure?

     

    I have tested a variation of your measure and it delivers the value for this week. See: