topic Forecast value in DAX Commands and Tips

Forecast value

Rohit001 — Sat, 06 Jan 2024 10:37:56 GMT

I am exhausted from trying to get this solution. i want to find out the forecast values of the next years through dax and want to show it in table format i was try but it not working correctly

Ihave two tables one is Sales Table(Year (2015 to 2018), Sales ) and one is Year Table(Year (2015 to 2023))

Re: Forecast value

Fowmy — Sat, 06 Jan 2024 13:43:04 GMT

Rohit001

How do you want to calculate the forecase for the years from 2018?
What sort of logic do you want to apply.

Explain it with some sample data

Re: Forecast value

Rohit001 — Sat, 06 Jan 2024 16:47:19 GMT

Year/Week

Re: Forecast value

Rohit001 — Sat, 06 Jan 2024 16:49:19 GMT

Previous day wise is possible ??

Re: Forecast value

Fowmy — Sat, 06 Jan 2024 19:26:28 GMT

Rohit001

Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.

Re: Forecast value

Rohit001 — Sun, 07 Jan 2024 04:35:54 GMT

File
https://drive.google.com/file/d/1wn7GStCyz3cx_WlIT-OOmUy4SFxb8Qrk/view?usp=sharing