topic WTD based on current Month in DAX Commands and Tips

WTD based on current Month

joshua1990 — Sun, 02 Aug 2020 08:47:25 GMT

Hello everyone!

I would like to compute a WTD sales measure based on the current month.

For this purpose I have a TRUE/FALSE column in my calendar table.

This filter is used on the report page.

Then I have a WTD measure:

SalesWTD = CALCULATE ( [Sales], FILTER ( ALL ( 'Calendar' ), 'Calendar'[Fiscal Year] = MAX ( 'Calendar'[Year] ) && 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) && 'Calendar'[Fiscal Week] = MAX ( 'Calendar'[Fiscal Week] ) ) )

Unfortunately, this measure is just running if a week is selected. It is not working with a currentMonth filter.

Do you know how to adjust this measure to get the WTD sales for the current week? Without a current week measure! I have also a MTD measure in the same matrix

Re: WTD based on current Month

Fowmy — Sun, 02 Aug 2020 10:31:43 GMT

joshua1990

Can you share your table or matrix where you try to use this formula?

You mentioned about Report Page filter? which measure is going in there?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

Re: WTD based on current Month

joshua1990 — Sun, 02 Aug 2020 11:42:08 GMT

Fowmy Thanks for your support!

The matrix has this structure:

Area	Sales WTD	Sales MTD
A	500	5000
B	300	650
C	250	357

The "IsCurrentMonth" measure is used to filter the whole page for the current month.