I want to create a new column to display QTD and NOT QTD. I used the below measures to display 'YTD/NOT' and 'MTD/NOT'.
How can I display QTD and NOT QTD based on current date?
- YTD/NOT = if('Date'[Invoice Month]<MONTH(TODAY()),"YTD",IF(AND('Date'[Invoice Month]=MONTH(TODAY()),'Date'[Day]<day(TODAY())),"YTD","NOT YTD"))
- MTD/NOT = IF(AND('Date'[Invoice Month]=MONTH(TODAY()),'Date'[Day]<day(TODAY())),"MTD","NOT MTD")
Perhaps the new QUARTER function?
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - August 2024
Check out the August 2024 Power BI update to learn about new features.
Fabric Community Update - August 2024
Find out what's new and trending in the Fabric Community.
