Forum Discussion

jcox's avatar
jcox
Icon for Advocate II rankAdvocate II
10 years ago
Solved

DATEDIFF when using Dates in a Column and using the TODAY() Function

So I feel like I've been close to finding a solution for a while, but I've been trying to write a measure that will take todays date from the TODAY() function, and subtract the date from a column alr...
Need Help
Tips and Tricks
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

Greg_Deckler's solution also works but again NOTE it has to be a COLUMN not a Measure! (you say you are trying to write a Measure)

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Sort of, you can actually write it as a Measure if you use an aggregation function like this:

 

Measure 2 = (TODAY() - MAX([Date].[Date])) *1.

That is a valid measure formula believe it or not.

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Greg_Deckler Seems that was your 2,000th post - Congratulations!

     

    Yes with MIN or MAX would work as Measure!