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!  

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!