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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.