Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date Counter Column

Hello All,   I am looking to create 1 column that counts each date that is older than today's date.   This Counter Column will be feeding from 4 other columns. Each column contain a specific date...
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi Anonymous ,

     

    How about this one:

     

    Here the code for the calculated column:

    Column = 
( Table[Date1] < TODAY() ) + ( Table[Date2] < TODAY() ) + ( Table[Date3] < TODAY() ) + ( Table[Date4] < TODAY() )

    Quite interesting, DAX considers TRUEs as 1 and FALSE as 0. That comes in handy in many cases, such as yours 🙂

     

    Let me know if this helps!

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

     

tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

Hi Anonymous ,

 

How about this one:

 

Here the code for the calculated column:

Column = 
( Table[Date1] < TODAY() ) + ( Table[Date2] < TODAY() ) + ( Table[Date3] < TODAY() ) + ( Table[Date4] < TODAY() )

Quite interesting, DAX considers TRUEs as 1 and FALSE as 0. That comes in handy in many cases, such as yours 🙂

 

Let me know if this helps!

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/