Forum Discussion

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
8 years ago
Hi,

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

Hope this helps.

Icon for Super User rank

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?

Icon for Super User rank

Super User

8 years ago

Hi,

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

sukumararumugam
Frequent Visitor
8 years ago
Hi Ashish..

You can access the sample from the below link.. Let me if you can't.

https://1drv.ms/u/s!AvuiYIpqHEiqgQPpZshW3vvvLs82

Thank you so much for your support!

Thanks!
- Ashish_Mathur
  Super User
  8 years ago
  Hi,
  
  I believe this is the result you want. You may download my PBI file from here.
  
  Hope this helps.
  - sukumararumugam
    Frequent Visitor
    8 years ago
    Hi Ashish,
    
    Thanks you so much for helping me on this!
    
    Can you Please help me in understaning the below function -
    
    DATESBETWEEN('Calendar'[Date],EDATE(MAX(Sheet1[Date]),-3)+1,MAX(Sheet1[Date]))
    
    in our case I know the MAX(Sheet1[Date]) will return 4/1/2018 and if I do -3 then it will return 1/1/2018 by adding 1 then 1/2/2018..
    as per the above understaning the result will be wrong. However the results on your file is right. So for sure I'm something here can you please help me in understanding.
    
    Thank you once again!
    
    Sukumar.