How to use AND function in Power BI

[ShreyasK]

I have table in which I want to keep rows which contains "null" and In time is greater than 05:20 from "InTime" column. And exclude rest other rows. Can anyone please help me.

Current Table:

User Name	InTime	OutTime
Steve	null	16:00
Lucy	5:34	17:10
James	null	18:05
Mike	1:30	14:00
Eric	0:30	null
Vincent	6:00	17:30

Expected result:

User Name	InTime	OutTime
Steve	null	16:00
Lucy	5:34	17:10
James	null	18:05
Vincent	6:00	17:30

I have tried with conditional column using OR function and advance filtering for InTime column using AND function but not getting expected results.

[Bifinity_75 · Accepted solution]

Hi @ShreyasK , you can use this measure:

In_Time = if(MAX('Table'[InTime])>TIME(5,20,0) || 
ISBLANK(max('Table'[InTime])),1,0)   

Follow, insert the measure "In_Time", in Filter, and give it the value 1, like the image:

Best regards