Forum Discussion

Helper III

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

Solution Sage

3 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()
)

Helper III

3 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