Forum Discussion
CustomForecast
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
5 Replies
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:
SergKolomiets T.y. good try but it not work with relations enabled, ineed relation between Base[date] and Date[Date]
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 ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-angzheng-msft I want put measure to values and date in columns on axis will be code, everything in matrix
