Week to Date Sales

[Anonymous]

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

[Tahreem24 · Accepted solution]

@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 · Accepted solution]

@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:

[Tahreem24 · Accepted solution]

@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!