Forecast Help

Question

I need Forecast DAX for the data given below. I need atleast 10 dates&nbsp; 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&nbsp;Name&nbsp; &nbsp; &nbsp; Count&nbsp; &nbsp; &nbsp;TRUE Date&nbsp; &nbsp; Hourgs-pls01&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 26/10/2023&nbsp; &nbsp; &nbsp;1gs-pls01&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 27/10/2023&nbsp; &nbsp; &nbsp;2gs-pls01&nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28/10/2023&nbsp; &nbsp; &nbsp;3gs-pls01&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;29/10/2023&nbsp; &nbsp; &nbsp;4gs-pls01&nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; 25/10/2023&nbsp; &nbsp; &nbsp;5gs-pls01&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; 24/10/2023&nbsp; &nbsp; &nbsp;6gs-pls01&nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; 23/10/2023&nbsp; &nbsp; &nbsp;7gs-pls01&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; 22/10/2023&nbsp; &nbsp; &nbsp;8gs-pls01&nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; 21/10/2023&nbsp; &nbsp; &nbsp;9gs-pls01&nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; 20/10/2023&nbsp; &nbsp; &nbsp;1gs-pls01&nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;19/10/2023&nbsp; &nbsp; 2&nbsp;

knp · Answer

That solution didn't work because ChatGPT gets things wrong often.
&nbsp;
See if you can adapt the solution here to what you need,&nbsp;https://community.fabric.microsoft.com/t5/Desktop/Forecast-with-DAX/td-p/1531519.
&nbsp;

knp · Answer

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.
&nbsp;

&nbsp;
&nbsp;

123abc · Answer

.

anonymous · Answer

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?

123abc · Answer

.

Forum Discussion

Forecast Help

6 Replies

Related content

Forecasting with DAX

Forecasting

Live Weather Forecast Dashboard

Forecast total display

Inventory Forecast