Hello, I have a UX view that displays clocked-in entries from a slice.
I want to show the view only when I have a clock in time, but am awaiting a clock out time.
I tried using this in the UX’s Show_If constraint, and although it is recognized as valid, it doesn’t seem to work.
Any suggestions?
UX Show_IF= AND(ISNOTBLANK(Time Entries[Clock In Date/Time]), ISBLANK(Time Entries[Clock Out Date/Time]))
The idea is to show the view only when a have a row that is not blank from the [Clock In Date/Time] column, whilst also having the column [Clock Out Date/Time] from the same row blank.
Thanks in advance,
+Josiah Seiler,
Try this:
ISNOTBLANK(ANY(SELECT(Time Entries[Keycolumn], AND(ISNOTBLANK([Clock In Date/Time]), ISBLANK([Clock Out Date/Time])))))
Worked perfectly, thanks a ton!
You are welcome.
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |