topic Re: Previous Quarter of Previous Year in DAX Commands and Tips

Previous Quarter of Previous Year

Migasuke — Thu, 19 May 2022 19:35:33 GMT

Hi,

I am searching for DAX solution, where in calculated column I mark most recent Q and also the same Q for previous year.
Here is my example (In Scope column is desired solution)

As we see, my latest data is for April 2022, which is Q2. Due to that I mark it as "Yes", but I also need to mark "Yes" the Q2 in previous year.

Any idea how to do it dynamic?

Re: Previous Quarter of Previous Year

Anonymous — Thu, 19 May 2022 20:01:47 GMT

HI if you have a date table it will be easy. Do you have it ?

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Re: Previous Quarter of Previous Year

Whitewater100 — Thu, 19 May 2022 20:14:58 GMT

Hello:

Can you try this calc column:(I added date table) and will attach file..https://drive.google.com/file/d/1W3cetda55qW0mKxle1XlAxKPSDQeot7w/view?usp=sharing

IsCurrent/prev/Qtr =

IF (OR(

YEAR ( data[Date] ) = YEAR ( TODAY () )

&& QUARTER ( data[Date] ) = QUARTER ( TODAY () ), YEAR ( data[Date] ) = YEAR ( TODAY ()-365 )

&& QUARTER ( data[Date] ) = QUARTER ( TODAY () -365)),

"Yes",

"No"

)

I hope this solves your question..Thanks