How to Compare Year over Year if there is Data inconsistency?

[anilpoda]

I have 3 years orders data. 1st year has data starting from 14th week, 2nd year 53 weeks data, 3rd year has only 9 weeks data. In this case how can I calculate YoY. Obviously, if I use YoY quick measure it will show negative value. How do I approach this situation?

Download Pbix file from below link. Also, provide few recommendations on how can I impove my report.

Blinds Pbix 

Thanks in Advance.

[NikhilChenna]

Hi @anilpoda ,

Try the below, 

Create the below measures and check it works.

total = SUM('table1'[abc])

previous year = CALCULATE(SUM('table1'[abc]), DATEADD('Date'[date],-1,Year)

YOY - DIVIDE(
( [total] - [previous year] ) , [previous year] )

Check if it works, replace table names and column names as per your data.

Regards, 
Nikhil Chenna 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[anilpoda]

Hi Nikhil,

Comparing 14 weeks data against 53 weeks data is not the right way to do when it comes to sales comparison. I need to compare only this year 14 weeks versus previous year 14 weeks. Kindly, read my post fully and propose DAX query for that.