Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
would really appreciate if somene can advise! thank you!
Here's everything you need to do CORRECT calculations on a custom financial calendar:
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
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.
Hi @Anonymous
Thank you! I will explore the link that you have shared and hopefully will find a solution from there.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |