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 ...
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)
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)