Forum Discussion
New Column based on values in another table
Hello, My end user wants to see Null in the Approver field if the Invoice Status is 'Paid' - and wants to see the Approver (field value) if the Invoice Status is other than 'Paid'. Invoice Status a...
Hi Anonymous
You can try this, but this would only work if you have a relationship set between your Invoice Header and LZ_Groups_Users Owner tables.
Revised-Approver = if ('Invoice Header'[Invoice Status] = "Paid", BLANK(), RELATED('LZ_Groups_Users Owner'[Approver]))If you use MAX the value will be the same for all that's not Paid, and it will be the last Approver on your table.
Hope this helps!
Jewel
Hi Jewel,
It is working fine. THANK YOU!
🙂
Nice!