Forum Discussion

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Measure If Date Less than Another Date

I need help to create a measure by referring to the below table.   Measure:- If the created_at is less than or equal to 90 days (of Calendar Date) it is "TRUE" else "FALSE".    
  • Sujit_Thakur's avatar
    6 years ago

    Dear gauravnarchal .
    This measure will do the work 

    Date_Measure = IF(
    SUMX(Sheet1,Sheet1[Created at ])<=(NOW()-90),
    "True",
    "False")

    Please give kudos by clicking thumbs up button , and if it solved then accept this post as solution
    please reply if any doubt 

    Regards ,
    Sujit 
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi gauravnarchal ,

    According to my understanding, you want to create a True/False flag when the date is within/not within 90 days(Comparing with the last day in the Created_at column), right?

     

    You could use the following formula:

    _diff =
    IF (
        DATEDIFF (
            SELECTEDVALUE ( 'diff'[Created_at] ),
            CALCULATE ( MAX ( 'diff'[Created_at] ), ALL ( diff ) ),
            DAY
        ) <= 90,
        TRUE (),
        FALSE ()
    )

    My visualization looks like this:

    Is the result what you want? If not, please upload some data samples and expected output.

    Please do mask sensitive data before uploading.

     

    Best Regards,

    Eyelyn Qin

  • Sujit_Thakur's avatar
    Sujit_Thakur
    6 years ago

    gauravnarchal  ,
    Please let me know that did you got your answer which i mentioned earlist of all .
    which was

    Date_Measure = IF(
    SUMX(Sheet1,Sheet1[Created at ])<=(NOW()-90),
    "True",
    "False")

    Kindly give kudos to motivate solution authors and please do accept my post as solution if it gave you what you wanted 

    Regards ,
    Thakur sujit