Forum Discussion

Anon2020's avatar
Anon2020
Helper I
1 year ago
Solved

Matrix Showing Difference Between Two Years

I have a matrix, shown below, that I want to show the difference between the two selected years. I am unsure of the formula to calculate the difference, but when I add it to the values of the matrix,...
Need Help
Tutorial Requests
  • v-hashadapu's avatar
    v-hashadapu
    11 months ago

    Hi Anon2020 , Thank you for reaching out to the Microsoft Fabric Community Forum.

     

    I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.

     

    Thank you for being part of the Microsoft Fabric Community!

Anon2020's avatar
Anon2020
Helper I
1 year ago

would be be so kind to show me?

GeraldGEmerick's avatar
GeraldGEmerick
Super User
1 year ago

Anon2020 I can certainly endeavor to do so. 

Measure = 
  VAR _maxFY = MAX( Opportunity[Opp_FY_c] )
  VAR _minFY = MIN( Opportunity[Opp_FY_c] )
  VAR _sumMaxFY = CALCULATE( SUM( 'Opportunity Product'[TotalCost] ), Opportunity[Opp_FY__c] = _maxFY )
  VAR _sumMinFY = CALCULATE( SUM( 'Opportunity Product'[TotalCost] ), Opportunity[Opp_FY__c] = _minFY )
  VAR _return = _sumMinFY - _sumMaxFY
RETURN
  _return

Hopefully this gets you the answer you are looking for or at least gets you close enough.