Forum Discussion
Post ProdigyWTD based on current Month
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
2 Replies
- Fowmy
Super User
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 🙂
joshua1990Fowmy 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.
