Count time using if function

[chrisyan_manalu]

Hi,

I have column Time (bins) below

And I'm create column to flagging when value of Time not blank then 0 else 1

The dax like this :

Index = IF([Time (bins)] <> BLANK(), 0,1)

When I'm filter Index equals to 1, value of time still there. The output should only "blank"

Anyone know how the dax should work ?

Please help

Thanks

[AntonioM · Accepted solution]

Please try this, 00:00:00 is being considered as blank, so you need to use 'strictly equal to' (==) instead

Index = IF( NOT ( [Time (bins)] == BLANK() ), 0,1)

[chrisyan_manalu]

This is work !!

Thank you