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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
saipawar
Helper IV
Helper IV

Calculate delta by row in a matrix

Sample Dataset - click here

tab 1 - input dataset 

tab 2 - desired output

 

Thanks

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@saipawar , Three measures like

 

Actual = sumx(filter(Table, Table[Source] ="Actual" ), [cost($)])
Plan = sumx(filter(Table, Table[Source] ="Plan" ), [cost($))
Delta = [Plan] -[Actual]

View solution in original post

2 REPLIES 2
saipawar
Helper IV
Helper IV

@amitchandak  The Plan numbers sum is not correct! 

amitchandak
Super User
Super User

@saipawar , Three measures like

 

Actual = sumx(filter(Table, Table[Source] ="Actual" ), [cost($)])
Plan = sumx(filter(Table, Table[Source] ="Plan" ), [cost($))
Delta = [Plan] -[Actual]

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.