Date value available, still returns as Blank

[MangeshVC]

Hi All.

I am facing a very strange situation where I have one table which has around 17k records & each record has date value and the data type is Date too.

I want to write one measure based on the date but it is not giving the desired result as date field treated as blank.

Below is the actual screenshot. I tried with MAX,MIN also, still same result. The below table visual values are coming from same table, so no issue of Relationship.

[Rakesh1705]

Hi Please check your data type once again. I have tried with the same formula what you have mentioned and it is working. Please check the snap.

[bhanu_gautam · Accepted solution]

@MangeshVC , First check for blank using below mentioned measure

CountBlanks = COUNTROWS(FILTER(tbl_Prev_Maintenance, ISBLANK(tbl_Prev_Maintenance[Planneddate])))

Then use hasonevalue function instead of selected value

ScheduledMaintenanceStatus =
IF(
HASONEVALUE(tbl_Prev_Maintenance[Planneddate]),
IF(
ISBLANK(SELECTEDVALUE(tbl_Prev_Maintenance[Planneddate])),
1,
0
),
BLANK()
)