Forum Discussion

derekli1700's avatar
derekli1700
Helper III
1 year ago
Solved

How to make a Percentage Change Column in Matrix Table

Hi - I would like to make a YOY percentage change column in my matrix table.  Heres my sample dataset: Category Customer Application Date A NexSys Solutions 1/12/2024 A CloudBridge In...
  • danextian's avatar
    1 year ago

    Hi derekli1700 

    Make sure to use a separate dates table and mark it as a date table

    Create a one-to-many single direction relationship

     

    Create this measure

    Delta = 
    VAR PrevYear =
        CALCULATE ( [Count], SAMEPERIODLASTYEAR ( CalendarTable[Date] ) )
    VAR Difference = [Count] - PrevYear
    RETURN
        DIVIDE ( Difference, PrevYear )
    

     

    Please see attached sample pbix