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! Go to 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.
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.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |