Forum Discussion

sukumararumugam's avatar
sukumararumugam
Frequent Visitor
8 years ago
Solved

Add Last Three Years and %YoY in Matrix Table

Hi All,   I'm very new to Power BI, can any one let me know how to derive the below result thru Matrix table?
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    I believe this is the result you want.  You may download my PBI file from here.

     

    Hope this helps.

     

sukumararumugam's avatar
sukumararumugam
Frequent Visitor
8 years ago

Please note that the years are should be dynamic and not constent. Meaning it should change based on the selection

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi sukumararumugam,

     

    If you can please provide some sample data with expected result to help us understanding your requirement and coding formula.

     

    Regards,

    Xiaoxin Sheng

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        In your base data, do you have a Month column?  Or still better, do you have a Date column?