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.

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.
  - Ashish_Mathur
    Super User
    8 years ago
    You are welcome. The MAX(Sheet1[Date]) will return the last date of the last quarter. So, if you have sales data till Q2 of 2018, the MAX(Sheet1[Date]) will return June 30, 2018. The EDATE() function goes back 3 months. So the result would be March 31, 2018. 1 added to this will reutrn April 1, 2018. So the DATESBETWEEN() function will reurn a Table of dates from April 1, 2018 to June 30, 2018.
    
    Hope this clarifies.