WTD Sales and WTD count calculation

[Anonymous]

Hi,

I'm trying to WTD sales and count of entries for same time period. Here's the couple of DAXs i'm using for WTD sales:

1) WTD = CALCULATE(SUM('SaT data'[Total Value]),FILTER('SaT data', DATESINPERIOD('SaT data'[EffectiveCloseDate],TODAY(),-7,DAY)))

2) 

WTD = IF (

HASONEVALUE ( 'Calendar'[Year] )

&& HASONEVALUE ('Calendar'[Fiscal Week]),

CALCULATE (

SUM ( 'SaT data'[Total Value]),

FILTER (

ALL ( 'Calendar' ),

'Calendar'[Year] = VALUES ( 'Calendar'[Year] )

&& 'Calendar'[Fiscal Week] = VALUES ( 'Calendar'[Fiscal Week] )

&& 'Calendar'[Date] <= MAX ( 'Calendar'[Date] )

)

),

BLANK ()

)

With both DAX queries, i'm getting a "Blank" value.

Can anyone help me with the correct query to get the numbers?

Thanks in advance!

[v-robertq-msft]

Hi, @Anonymous 

According to your DAX formula, it seems don’t have any problem. It’s hard to tell why it shows blank, I think the first you should check is whether there is data in the time period you requested.

If you still have a problem, would you like to post some sample data(without sensitive data) and your expected result so that we can help you in advance and figure out where the problem is?

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer my video or blog can help on this

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

or

https://www.youtube.com/watch?v=pnAesWxYgJ8

[Anonymous]

Hi @amitchandak , I've been through the links but it isn't giving me any results with the queries in the blog.