Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
6 years ago
Solved

Days between dates not working

hi Below is what my formula for calculating days days = 'Pipeline Extract'[AnticipatedWinDate] -(TODAY())  and i am getting output like below, not sure whats wrong i was expecting a output showi...
Need Help
Show and Tell
  • az38's avatar
    az38
    6 years ago

    Hi vjnvinod 

    also you could try DATEDIFF() function

    Column = DATEDIFF('Pipeline Extract'[AnticipatedWinDate],TODAY(),DAY)

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

Hi vjnvinod 

also you could try DATEDIFF() function

Column = DATEDIFF('Pipeline Extract'[AnticipatedWinDate],TODAY(),DAY)

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

vjnvinod's avatar
vjnvinod
Impactful Individual
6 years ago

worked like a charm