Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all, I am trying to collate both YTD (actualized sales) & YTG (forecast) in power BI to show as a bar chart to show total end game for the year.
Basically if date is less than this month (e.g. today = 6th Dec, YTD (from actual sales source) would be till 30th Nov 2019) If not take forecast. The data source for actual sales & forecast resides separately but already has a relationship (common column linking up SKU, customer & date of sales)
Can anyone one advise on the fomula I should use?
Appreciate your help in advance!
Solved! Go to Solution.
Hi crazyshoots,
You could refer to my sample to see whether it work or not.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dax, for the first graph I'd be expecting to see only one bar instead of clusters..
Example today is 9th Dec 2019, the last complete month data = Nov 2019.
Hence the data from Jan - Nov 2019 would be actuals, while the last bar of the year for Dec 2019 would be forecast.
Kindly assist?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
77 | |
72 | |
65 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |