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?

      • sukumararumugam's avatar
        sukumararumugam
        Frequent Visitor
        8 years ago

        Hi Ashish,

         

        Sorry for the late reply.. Yes I have Column for each date and also seperate field for Month.

         

         

        Thanks!