Forum Discussion

navneet0512's avatar
navneet0512
Icon for Helper III rankHelper III
2 years ago

Quarter over Quarter analysis Analysis

Want to calcualte Quarter VS Quarter for below data in power bi quarter and year column is not in date format .  
Need Help
navneet0512's avatar
navneet0512
Icon for Helper III rankHelper III
2 years ago

After date column creation :- If i am selecting quarter 2009Q2 then in date column it is 01/01/2009

 

Kishore_KVN's avatar
Kishore_KVN
Icon for Solution Sage rankSolution Sage
2 years ago

Got it, create this way then

Date Column = 
Switch(True(),
Right(Quarter_Column,1) = 1 , DATE(Year_Column,01,01),
Right(Quarter_Column,1) = 2 , DATE(Year_Column,04,01),

Right(Quarter_Column,1) = 3 , DATE(Year_Column,07,01),

Right(Quarter_Column,1) = 4 , DATE(Year_Column,10,01),

BLANK()
)

  • navneet0512's avatar
    navneet0512
    Icon for Helper III rankHelper III
    2 years ago

    First I created A date column like below :- 

    Then created a calendar table :- 

    Then build realtionship between :- Calendar date column and RaW date_column .
    Than calcualted QOQ as per your refrence :- 

    Not able to get the QOQ why? Kishore_KVN