I have a code as below. Moth May should be in Quarter 1
= QUARTER(TODAY())
but QUARTER('Calendar'[Date])
seems not producing the same output. is there a reason for that ? many thanks in advance.
get_current_quarter =
IF(
AND(
QUARTER(TODAY()) = QUARTER('Calendar'[Date]),
YEAR(TODAY()) = YEAR('Calendar'[Date])
),
"Yes",
"No"
)