Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
My sample table is as below:
Tickets | FY | Qtr |
A2 | FY19 | Q1 |
A4 | FY19 | Q2 |
A1 | FY19 | Q3 |
A5 | FY19 | Q3 |
A33 | FY19 | Q2 |
A412 | FY19 | Q4 |
A153 | FY19 | Q1 |
A512 | FY19 | Q1 |
I've summarize the data by FY and Qtr with count(Tickets) as values. I want to calculate QoQ based on Qtr column. I do not have any date table. Want to find the difference between current qtr Vs previous qtr.
thanks
Solved! Go to Solution.
Hi @jogenpatel ,
Looking at your data and considering you don't have a date table you can try something similar to what is below:
QoQ = VAR CurrentQuarter = MAX ( Quarter_Calculation[Qtr] ) RETURN IF ( RIGHT ( CurrentQuarter; 1 ) - 1 = 0; COUNT ( Quarter_Calculation[Tickets] ); COUNT ( Quarter_Calculation[Tickets] ) - CALCULATE ( COUNT ( Quarter_Calculation[Tickets] ); FILTER ( ALL ( Quarter_Calculation[Qtr] ); Quarter_Calculation[Qtr] = CONCATENATE ( "Q"; RIGHT ( CurrentQuarter; 1 ) - 1 ) ) ) )
Be aware that this is not making calculation with change of year, only quarter.
Regards.
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @jogenpatel ,
Looking at your data and considering you don't have a date table you can try something similar to what is below:
QoQ = VAR CurrentQuarter = MAX ( Quarter_Calculation[Qtr] ) RETURN IF ( RIGHT ( CurrentQuarter; 1 ) - 1 = 0; COUNT ( Quarter_Calculation[Tickets] ); COUNT ( Quarter_Calculation[Tickets] ) - CALCULATE ( COUNT ( Quarter_Calculation[Tickets] ); FILTER ( ALL ( Quarter_Calculation[Qtr] ); Quarter_Calculation[Qtr] = CONCATENATE ( "Q"; RIGHT ( CurrentQuarter; 1 ) - 1 ) ) ) )
Be aware that this is not making calculation with change of year, only quarter.
Regards.
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks, that worked!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |