Forum Discussion
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...
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 🙂
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 🙂