Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |