Comparing dates in the maximum Selected date with the column of the table via If and Else statement
I am trying to compare the dates in the maximum Selected date with the column of the table via If and Else statement and it is not working as expected. It seems like somehow it is not recognizing the measure as dates. My Measure to have the maximum date selected: MaxPostDateSelected = CALCULATE(MAX((PostDate[Date])),ALLSELECTED(PostDate[Date])) If and else statement for the table Maint with the Post_date as the column: PostDateCheck = if(Maint[Post_Date]>=[MaxPostDateSelected],"YES","NO") The formula runs but it is not working as expected.