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: ...
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
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