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.

     

15 Replies

  • 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