Forum Discussion
Helper IIIQuarter over Quarter analysis Analysis
Solution SageHello navneet0512 ,
Create one new date column with the help of that year column.
Date Column = DATE('TABLE'[Years],01,01)
Then create new calendar table then create relationship with this date column and calculate Quarter Over Quarter.
You can use below calculation for reference.
QoQ Sales Change =
VAR CurrentQuarterSales = SUM('YourTable'[Sales])
VAR PreviousQuarterSales = CALCULATE(SUM('YourTable'[Sales]), DATEADD('DateTable'[Date], -1, QUARTER))
RETURN IF(ISBLANK(CurrentQuarterSales) || ISBLANK(PreviousQuarterSales), BLANK(), (CurrentQuarterSales - PreviousQuarterSales) / PreviousQuarterSales)
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Helper IIIAfter date column creation :- If i am selecting quarter 2009Q2 then in date column it is 01/01/2009
- Kishore_KVN
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
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