Forum Discussion

KeriHHBB's avatar
KeriHHBB
New Member
7 years ago
Solved

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 tas...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Try this calculated column formula

     

    =[Planned Finsh Date]-TODAY()

     

    Hope this helps.

  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

KeriHHBB's avatar
KeriHHBB
New Member
7 years ago

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's avatar
v-juanli-msft
Community Support
7 years ago

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