How to create a measure using date column without aggregation?

[Anonymous]

I have 2 date columns that need to be compared to each other to see which date is greater than the other. If date1 > date2 then 0. If date1 < date2 then 1. From there I need to calculate the average between those 0-1 values. When performing DAX 

[v-yalanwu-msft · Accepted solution]

Hi， @Anonymous ；

You could create a measure as follow:

flag2 = 
AVERAGEX(SUMMARIZE('Table',[Date1],[date2],
"1",IF(MAX('Table'[Date1])>MAX('Table'[date2]),0,1)),[1])

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dinesh_Suranga]

@Anonymous ,

Hi,

Use SELECTEDVALUE function.

Thanks