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 shows Office Visits.  This table is unioned into 5 other tables to give me specific values by Quarter, by Month as the headers.  The next row level is year of the VALUES.  So I need to create a row below 2021 for each month for each row heading (in this instance Office Visits and New Visits), that is the difference of 2020 and 2021.  Is there an easy way to do this?  Thanks in advance.  

 

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!  

3 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    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
      Post Patron
      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?