Trying to calculate days remaining

[ahmed-97]

As mentioned in the subject, I'm having trouble creating a measure for my days remaining for using the todate from my data.

I have made sure that the column is formatted as date. However I still can not link the column in any measure. I have tried using datediff, max, min but nothing worked.

I am able to create a column using the formula, but would that be ideal? 

[rajendraongole1 · Accepted solution]

Hi @ahmed-97 - Can you try with the below measure to get the days remainings

Days Remaining =
IF (
MAX('YourTable'[ToDate]) >= TODAY(),
DATEDIFF(TODAY(), MAX('YourTable'[ToDate]), DAY),
BLANK()
)

Hope it helps 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[ahmed-97]

This actually worked, Thank you so much!