Dax - Previous Quarter error Help

[agd50]

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

[wdx223_Daniel · Accepted solution]

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)