Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?