Forum Discussion
Solved
Dax - Previous Quarter error Help
I have made an error with my calculation - I didn't account for the q1 of the new year - instead I get 0Q. I would like to show the previous quarter, including showing Q4 of last year in the first calendar year quarter. Got any ideas?
Previous Quarter Year Title =
Var Year = INT ( YEAR ( TODAY () ) )
Var Quarter = INT ( FORMAT(NOW (),
"q" ) )
Return
"Q"&Quarter-1 &"," & " " & Year
(Should instead show Q4 of last year for the text)
TIA
the best practice is to create a date table, and use the time intelligense functions.
or try this
return "Q"&IF(Quarter=1,Quarter+3 &", "&Year-1,Quarter-1&", "&Year)
1 Reply
the best practice is to create a date table, and use the time intelligense functions.
or try this
return "Q"&IF(Quarter=1,Quarter+3 &", "&Year-1,Quarter-1&", "&Year)