cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## 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

2 ACCEPTED SOLUTIONS
Super User

Hi,

Try this calculated column formula

=[Planned Finsh Date]-TODAY()

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Support

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 5
Super User

Hi,

Try this calculated column formula

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

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Support

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

New Member

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.

Community Support

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

Super User

Hi,

Try this calculated column formula

=[Planned Finsh Date]-TODAY()

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors