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,
Why do huge difference is coming between Last7d(22425822 etc) and Last7d avg(13.09 etc) values which has shown in below table.could any one please modify my dax.
Have you check manually which one is correct. Check the Sum and Avg using this
Sales 10 Days = ( VAR _Cuur_start = Max('Compare Date'[Compare Date]) -7 VAR _Curr_END = Max('Compare Date'[Compare Date]) return calculate((sum(Sales[Sales Amount]),Sales[Sales Date] >= _Cuur_start && Sales[Sales Date] <= _Curr_END ) )
Hey,
My guess is that you are using SUMX instead of SUM, so you are basically summing the entire sales table and then calculate what that is for the 7d.
Try changing SUMX by SUM
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |