Show if: Field in latest record on another table with matching ID is blank

I'm getting a little confused with the documentation and how to use all the commands together to reach this conclusion. can anyone help?

In the Show If I just want to check if the time field of the last (newest) record on a different table containing their ID is blank. 

any help would be appreciated, thanks.

Solved Solved
0 1 87
1 ACCEPTED SOLUTION

Please try below

1. Create a slice called say "LastRow_Time" on the "Other Table" with a slice filter expression something like   [Other Table Key Column]= MAXROW("Other Table, "_ROWNUMBER")

2. In the show_if of the column, please try 

        ISBLANK(LastRow_Time[Time Column in the other table])

Please replace table, column names with the actual column names you have.  Please note this approach could once in a while fail in a multi user environment, if two users add rows to the other table simultaneously.

View solution in original post

1 REPLY 1

Please try below

1. Create a slice called say "LastRow_Time" on the "Other Table" with a slice filter expression something like   [Other Table Key Column]= MAXROW("Other Table, "_ROWNUMBER")

2. In the show_if of the column, please try 

        ISBLANK(LastRow_Time[Time Column in the other table])

Please replace table, column names with the actual column names you have.  Please note this approach could once in a while fail in a multi user environment, if two users add rows to the other table simultaneously.

Top Labels in this Space