Measure to see if after project start date

[Anonymous]

Hi,

I would like to create a measure to see if value occured on or after project start date, which is a measure. Struggling with this.

Table I have with this measure is not correct:

Measure 3 = IF(MIN(ID_registration[date_reg]) >= [Project Start date], 1, 0)

Link to my pbix file: https://ufile.io/02msuxn5

Thanks!

[MFelix · Accepted solution]

Hi @Anonymous ,

Not really sure if you need to have the lines that are blanked on your table but you can use the measure below:

Measure 3 =
SWITCH (
    TRUE,
    [Project Start date] = BLANK (), BLANK (),
    SELECTEDVALUE ( 'measure'[date] ) >= [Project Start date], 1,
    0
)

Be aware that I'm using the measure date column since is the one that is giving context to your measure, if you use another column date you need to use that column in your measure.

Check PBIX file attach.

[Anonymous]

Great! Just what I was looking for!

Thanks @MFelix!