Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 something like the table below, where Power BI would detect the last month the Contractor earned something (2021 May), and then it would do two things:
1- Calculate the amount of months remaining at the given Average Earned so far
2- Project the Average Earnings for the remaining months.
I had no issue on getting item 1, however I am still having a hard time to get the Average projected through the remaining months to complete.
Any ideas ?
Thanks,
Solved! Go to Solution.
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
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
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |