Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
Hi,
Try this calculated column formula
=MAX([Planned FInish Date],[Actual FInish Date])-MIN([Planned FInish Date],[Actual FInish Date])
Hope this helps.
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 @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
Hi,
Try this calculated column formula
=[Planned Finsh Date]-TODAY()
Hope this helps.
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |