Forecast Dax Full Year

[binary]

I have 1 month data last year and 1 month of this year. How do I forecast the sales for 2023 monthly?

[v-yangliu-msft · Accepted 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

[ribisht17]

@binary 

This data is not enough to forecast

Forecasting in Power BI. A visual step-by-step guide to… | by Ednalyn C. De Dios | Towards Data Scie...

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 

[binary]

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?