Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |