CustomForecast

[Digger]

I have data source like

with multiples codes

I need make measure which should do something like that

Fomula:  If Percent >=10 then predict each next month goes by 15 percent until get 100

So how to write measure to achive that?

I found this article http://blog.gbrueckl.at/2015/04/recursive-calculations-powerpivot-dax/ it partialy that what i want but problem is there are no PBX file only DAX inside Xlsx and i cant move measures to PBI as they not work

First prolem with @SergKolomiets  example, is what showing empty column without data

And Sums not goes to each month, so i cant multiply sum of all dates grouped by code by percentage

https://file.io/y2wvQ49hNe6q

[SergKolomiets]

Good afternoon. There are two tables that are not related to each other: the Date calendar and the Base source table. The measure is as follows:

[Digger]

@SergKolomiets  T.y. good try but it not work with relations enabled, ineed relation between Base[date] and Date[Date]

[SergKolomiets]

[v-angzheng-msft]

Hi, @Digger 

The logic here is not too difficult to implement.But just curious how you would like to display in Power BI to get the results.Add a column for each month up to the maximum date, like in the image above? Or generate a forecast trend for each month on a line chart?

Please share more details about what you want to achieve with PowerBI

Best Regards,
Community Support Team _ Zeon Zheng

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

[Digger]

@v-angzheng-msft   I want put measure to values and date in columns on axis will be code, everything in matrix