Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I am looking to calculate the dax query some thing like below(Measure or column). Variance should be the output which is difference the weeks like diff between week2 and week1 is -1
| Week | Sales | Variance |
| 1 | 6 | 6 |
| 2 | 5 | -1 |
| 3 | 8 | 3 |
| 4 | 7 | -1 |
| 5 | 4 | -3 |
| 6 | 3 | -1 |
| 7 | 2 | -1 |
| 8 | 0 | -2 |
| 9 | 10 | 10 |
| 10 | 12 | 2 |
Solved! Go to Solution.