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
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!

  • 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.