WTD based on current Month

[joshua1990]

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

[Fowmy]

@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

[joshua1990]

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