Forum Discussion
Date value available, still returns as Blank
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.
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()
)
2 Replies
- bhanu_gautam
Super User
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()
)
