Forum Discussion
Solved
How to use AND function in Power BI
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.
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
1 Reply
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