Forum Discussion
gauravnarchal
Post Prodigy
6 years agoMeasure 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".
- 6 years ago
Dear gauravnarchal .
This measure will do the workDate_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 - Anonymous6 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
- 6 years ago
gauravnarchal ,
Please let me know that did you got your answer which i mentioned earlist of all .
which wasDate_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
Sujit_Thakur
Solution Sage
6 years agoDear 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 ,
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
- Sujit_Thakur6 years ago
Solution Sage
gauravnarchal ,
Please let me know that did you got your answer which i mentioned earlist of all .
which wasDate_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