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

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.