Forum Discussion
Forecast Dax Full Year
I have 1 month data last year and 1 month of this year. How do I forecast the sales for 2023 monthly?
Hi Anonymous ,
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
3 Replies
Anonymous
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 UsersHello 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?
Hi Anonymous ,
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
