Forum Discussion
Solved
Current Quarter in Date Table
Hi, I was trying to create the current quarter yes or no in the date table. But my below dax is not happening. current quarter = IF(ROUNDUP(MONTH('Base Date'[Date])/3, 0)=ROUNDUP(MONTH(TOD...
Akhil_1411 , better to qtr start and end day .
If(Today()>=[start qtr] && today()<=[end qtr], "Current Qtr", "Other Qtr")
For qtr start date yoy can use startofquarter for standard qtr and for end date endofquarter
or refer :
Glad you have got the solution😉. Sorry that I don't refresh website before posting.