The task looks easy but I am stuck on this, so anyone know how to count null like in the image
I wanna count all the null cells in that table on the right, this means every day that there is no sale(measure field = qty_sold)
Just explaining a bit more
I have an master calendar (day,month,year...) creating every day from the min(date) to max(date)
This formula gets all the day that are not null but I wanna just the opposite
someone to help??