Forum Discussion

Razorbx13's avatar
Razorbx13
Post Patron
5 years ago
Solved

Row Difference

I have the below matrix.  The measure is a single field (VALUE) which results from a union of several tables (one being office visits).  Each row total comes from a single table.  The example below s...
Need Help
Show and Tell
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Razorbx13 ,

     

    sure, you can create a measure with the value from the previous year with SAMEPERIODLASTYEAR :

    Measure Last Year = CALCULATE( [myMeasure], SAMEPERIODLASTYEAR( DateTable[Date] ) )

     

    Then you just have to subtract one measure from the other and you have your result.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • Razorbx13's avatar
    Razorbx13
    5 years ago

    So will this be a measure I can place RIGHT BELOW the 16298, 15727, 4027, etc.?  Will try it out tonight!  

Razorbx13's avatar
Razorbx13
Post Patron
5 years ago

I guess I can help and make a little clearer.  What I will be showing once all the data is there is a 2020 "positive" number and a 2021 "positive" number.  The total line needs to show the net of these two numbers, not the sum.  Is that doable?  I need to show each number as a positive, but in the total line need to show the net.  Is that doable?