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.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper 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!

    • sukumararumugam's avatar
      sukumararumugam
      Frequent Visitor
      8 years ago

      Also is it possible to get the below view in Power BI, where Q2'QoQ will be dynamic- meaning based on the latest Quarter selected Vs Previous Quarter.

       

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Share the link from where i can download your PBI file.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        Hi,

         

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

         

        Hope this helps.