Forum Discussion

rocky_puff's avatar
rocky_puff
Frequent Visitor
5 years ago
Solved

Validating date row, cannot determine what to compare for missing date row - using IF

Hi. Currently I have a task where I need to validate - if a Shop declared its status that day, so a Date row will created in the dataset. When I want to make a summary whether the Shop had declared o...
  • rocky_puff's avatar
    rocky_puff
    5 years ago

    I have found the solution. Maybe I overthink too much. So here is the solution that I used for my problem (eventhough im not sure how it works, but it works!) 🙂

     

    Declaration = IF(MAX(February2021[Date]) == BLANK(), "No", "Yes")

     

    It will then produce the outcome that I want ! Thanks everyone, I hope it helps you too 🙂

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

rocky_puff , Not clear on the need of this column.

 

you can create a measure

measure = if(countrows(Table)+0=0,"No", "Yes")

 

Jan , feb should be filter from UI on the visual

rocky_puff's avatar
rocky_puff
Frequent Visitor
5 years ago

I've tried the measure you proposed. But still can't get the "No".

 

 

The Comparison Column is to show the result after validating whether the date exist or not (in other word, to validate whether the shop did or did not declare their status on that day)