Project Dates

[livjay97]

Hello! I am trying to create a table in Power BI which will show time elapsed and time remaining in a project.

There's a few things I am trying to do:

I have the project contract start date and the end date but how do I populate a column to update with today's date?

Then I am guessing I will need a measure to calculate months remaining (end date - today date) and time elapsed with (today's date - start date)

Any help will be greatly appreciated!

[Anonymous · Accepted solution]

Hi @livjay97 ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create measures.

There are different in all and Measure. You can choose the right measure according to your data.

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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