Forum Discussion
joshua1990
Post Prodigy
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. T...
Fowmy
Super User
Super Userjoshua1990
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 🙂
joshua1990Post Prodigy
Post ProdigyFowmy 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.