Forum Discussion
Finish date variance
Hi
I'm very, very new to Power BI......
I've prepared a report in table format linked to data from MS Project Online.
I need to include a column that sets out how many days overdue a task is compared to its planned finish date is. I can see how to show the variance between a finish date and a baseline finish date, however that isn't what I'd need.
Thanks
Hi,
Try this calculated column formula
=[Planned Finsh Date]-TODAY()
Hope this helps.
Hi KeriHHBB
Please try this formula
Column = DATEDIFF([planned finish date],TODAY(),DAY)
This formula would calculate [the planned finish date]- today's date, thus you know how many days the task delays.
Best Regards
Maggie
5 Replies
Hi KeriHHBB
Assume your table is like
Create a calculated columns in "Modeling"->New columns
Column = DATEDIFF([planned finish date],[actual finish date],DAY)
Best Regards
Maggie
Hi
Thanks for your responses.
In fact I want to compare the planned finish date against today's date so that I can see which tasks are late, and by how many days.
Hi,
Try this calculated column formula
=[Planned Finsh Date]-TODAY()
Hope this helps.
Hi,
Try this calculated column formula
=MAX([Planned FInish Date],[Actual FInish Date])-MIN([Planned FInish Date],[Actual FInish Date])
Hope this helps.
