Forecast Help

[Anonymous]

I need Forecast DAX for the data given below. I need atleast 10 dates  of forecast and data. Purpose is to visualize the data in a table based on date and time. Tried many dax but they are not working properly. Please guide me

Name      Count     TRUE Date    Hour
gs-pls01     2          26/10/2023     1
gs-pls01     1          27/10/2023     2
gs-pls01      3         28/10/2023     3
gs-pls01      1         29/10/2023     4
gs-pls01       3        25/10/2023     5
gs-pls01       1        24/10/2023     6
gs-pls01       4        23/10/2023     7
gs-pls01       1        22/10/2023     8
gs-pls01       5        21/10/2023     9
gs-pls01       2        20/10/2023     1
gs-pls01       2         19/10/2023    2

[123abc]

.

[Anonymous]

Thank You. But I have a question. What kind of calculation are we using as forecast method? I have used your dax but the result seems unreal. Is it possible to use any exisiting forecast method using DAX?

[KNP]

That solution didn't work because ChatGPT gets things wrong often.

See if you can adapt the solution here to what you need, https://community.fabric.microsoft.com/t5/Desktop/Forecast-with-DAX/td-p/1531519.

[123abc]

.

[Anonymous]

TIME_SERIES_TOTALQ function is not working. not a valid function they say

[KNP]

Like I said, his answers are straight from ChatGPT which is often wrong.

See if you can adapt the solution in the link I posted or maybe provide some more detail of your expected output.