Finish date variance

[KeriHHBB]

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

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

=[Planned Finsh Date]-TODAY()

Hope this helps.

[Ashish_Mathur]

Hi,

Try this calculated column formula

=MAX([Planned FInish Date],[Actual FInish Date])-MIN([Planned FInish Date],[Actual FInish Date])

Hope this helps.

[v-juanli-msft]

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

[KeriHHBB]

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.

[v-juanli-msft · Accepted solution]

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

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

=[Planned Finsh Date]-TODAY()

Hope this helps.