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.
I have 1 month data last year and 1 month of this year. How do I forecast the sales for 2023 monthly?
Solved! Go to Solution.
Hi @binary ,
Do you mean making two columns into one?
You can select [Actual Expense] and [Forcase] two columns in Power query - right click - Merge Columns.
For the new column [Merge] – Change Type – Decimal Number.
Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @binary ,
Do you mean making two columns into one?
You can select [Actual Expense] and [Forcase] two columns in Power query - right click - Merge Columns.
For the new column [Merge] – Change Type – Decimal Number.
Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This data is not enough to forecast
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
Hello @ribisht17 ,
I tried doing it in excel and provided results through Linear Forecast but my problem is with the visuals as there was a gap visible. is this something we could resolve instead?
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 |
---|---|
49 | |
26 | |
19 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |