Forum Discussion
Solved
Measure to Forecast based on average
Hello, I am having a hard time to create a DAX formula that will create a projection of when a project will be completed based on how much is being Earned per month. I am trying to achieve someth...
1 create a date table, mark it as date table, and create a column of "YearMonthNumber"
2 create a relationship between fact table and date table with date columns
3 create two measures
wdx223_Daniel
Community Champion
Community Champion1 create a date table, mark it as date table, and create a column of "YearMonthNumber"
2 create a relationship between fact table and date table with date columns
3 create two measures
Thank you very much Daniel, it worked perfectly ! I am still kind trying to understand the magic you've done to create the logic in which Power BI would project these values forward, but I am very happy with your solution.
