YTD Linear Chart

[Anonymous]

Hi All

I am trying to build a daily line chart to compare YOY betwen YTD FY21 and YTD FY22.

FY21 consist of all actual sales while FY22 consist of partial actual sales and forecast numbers. Both actuals and forecast are in different tables.

As you can see below, i tried to compare the sales in same day/month in different year but due to unique dates in both years (eg: 18th Aug 2020 and 18th Aug 2021), the line charts cannot be presented in an overlay manner.

I also tried to pull in Month-Day in X-Axis instead of date but the whole calculation will run and become incorrect. Below are my functions:

YTD FY21 = TOTALYTD([Actual FY21],'Calendar'[Date],"1/31")

YTD FY22 Team Commit = TOTALYTD([Forecast Team Commit],'Calendar'[Date],"01/31")

YTD FY21 % = DIVIDE([YTD FY21],[Grand Total Actual FY21])

YTD FY22 % = DIVIDE([YTD FY22 Team Commit],[Grand Total Team Commit Forecast FY22])

would really appreciate if somene can advise! thank you!

[Anonymous]

Here's everything you need to do CORRECT calculations on a custom financial calendar:

Custom time-related calculations – DAX Patterns

[Anonymous]

Hi @Anonymous 

Thanks for your reply.

Are you saying that my functions are wrong which are causing the issue whereby I cannot present the YOY on month/day in X-axis?

I just want the two years YTD trend to show together above/under each other for the purpose of comparison. Is there a workaround for this please?

Thank you.

[Anonymous]

@Anonymous 

All I'm saying is that you should do things RIGHT and never try to re-invent the wheel. Please follow Best Practices of the field and you'll be safe.

[Anonymous]

Hi @Anonymous 

Thank you! I will explore the link that you have shared and hopefully will find a solution from there.