Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculate Task Completion and Display the message "Completed".

              Above screen shot. Created new column with .....  Days Left or OverDue = 'XXX'[Actual Due Date]-TODAY() ..... to calculate the days left or overdue. But some tasks alrea...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    Since the [Completion %] doesn't have a total value, please try the formula below.

    Days Left or OverDue =
VAR days =
    DATEDIFF ( MIN ( [Actual Due Date] ), TODAY (), DAY )
RETURN
    IF (
        ISBLANK ( [Completion %] ),
        BLANK (),
        IF (
            [Completion %] = 1,
            "Completed",
            IF ( days > 0, days & " Days Overdue", - days & " Left" )
        )
    )

    Best Regards,

    Dale

  • AdamBoltryk's avatar
    AdamBoltryk
    8 years ago

    Hi, Isn't your total just standard PBI's total? you can turn it off here:

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Dale,

 

Thank you so much, solution is working fine. Except the total, I tried to hide the total number of days as showing 101-Days Overdue. Do you have any solution to hide the last Row of Total. 

 

Regards,

Bix.

AdamBoltryk's avatar
AdamBoltryk
Icon for Resolver I rankResolver I
8 years ago

Hi, Isn't your total just standard PBI's total? you can turn it off here:

Related content