Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Krisvenkata11
Frequent Visitor

Calculate variance between 2 weeks

 

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

WeekSalesVariance
166
25-1
383
47-1
54-3
63-1
72-1
80-2
91010
10122