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.
can someone help me how to perform YOY%, QOQ% calculation using DAX.
YOY%= mar-17(net_sale) - mar-16(net_sale)/mar-16(net_sale)
QOQ%= mar-08(net-sale) - dec-07(net_sale)/dec-07(net_sale)
NOTE : All the fields are in string format
Solved! Go to Solution.
Hi @Anonymous,
Could you please mark the proper answer as solution?
Best Regards!
Dale
Hi @Anonymous,
Could you please mark the proper answer as solution?
Best Regards!
Dale
Hi @Anonymous,
The first step is changing the data type to a proper type. You can try it out in this file.
1. Create a date table.
Calendar = CALENDARAUTO()
2. Establish relationships with other two tables.
3. Create two measures.
YOY% = VAR thisYear = SUM ( YOY[Net_sales] ) VAR lastYear = CALCULATE ( SUM ( YOY[Net_sales] ), SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) ) RETURN DIVIDE ( thisYear - lastYear, lastYear, 0 )
QOQ% = VAR thisQ = SUM ( 'QOQ'[Net_sale] ) VAR lastQ = CALCULATE ( SUM ( QOQ[Net_sale] ), DATESINPERIOD ( 'Calendar'[Date], MIN ( 'Calendar'[Date] ), -1, QUARTER ) ) RETURN DIVIDE ( thisQ - lastQ, lastQ, 0 )
Best Regards,
Dale
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 |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |