topic Re: how to get forecasting for next weeks up to end of the year in DAX Commands and Tips

how to get forecasting for next weeks up to end of the year

Mishary — Mon, 14 Nov 2022 06:32:56 GMT

Hi !

I've been trying to find a solution for a few days, but I can't find it

what i'm trying to do is to get forecasting for next weeks up to end of year based in trend from the first week up to the last week

I was to do this manually by Excel using trend function

below show how i get trend by Excel

So how can I forecasting kpi from 41 week up to 53 week based in trend from first week up to 40 week by using DAX ?

In my data model i have date table and operations table so the table above is just to explain what i'm trying to do

I hope someone can help

Mishary — Mon, 14 Nov 2022 18:29:16 GMT

Is there any clarification i can do

Anonymous — Tue, 15 Nov 2022 09:39:03 GMT

Does prediction mean calculating linear regression?

You can view the following documentation:

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mishary — Thu, 17 Nov 2022 04:47:56 GMT

Thanks Anonymous

i tried this and it's work !

Thanks for your help