I need to filter à column by another Column in my RLS
Hi, I have two tables and I need one to filter the other but i tried several methods and it doesn't work for apply my dynamic RLS. I have already filter the list of CODE_CP (in tec_tab_regroupement) by the user email. I need the list in the table Tec_Tab_Regroupement[CODE_CP] to filter a more complete list in the table Tec_bridge_Ref[CODE_CP]. Thanks for your help Guillaume
Dax to find correct name from two tables
Hello All, I have two data sets one is the ALL orders Table which contains both Product delivery and Product return records and the other table is the Return Data table which contains info about products which only returned by customers. I am trying to get the right Delivery driver's name and Pickup driver's name from these two data sets. Output: Adding a Delivery driver's name and Pickup driver's name columns to the Returns table. The sample dataset and explanation using various scenarios are as follows: Scenario 1: 1. The Order number contains multiple products and was delivered initially by the driver, John (delivery driver), on 09/21/2022. The customer returned all products The **bleep** up driver ( Max) on 09/23/2022. 2. After that the new products are delivered again to the customer on 09/25/2022 by Jose (New Delivery Driver). The customer returns one product (A1234) on 09/26/2022 to the picky driver ( Carlos). So I want to show respective Drivers based on the date. Scenario 2: The driver picked up a return that was initially delivered 2 years back. Therefore The orders table doesn't contain data. So the Delivery measure should show blank. Scenario 3: 1. Driver picks up the product on 09/27/2022 but he updates the system on 09/28/2022. The sample data: All Orders Table: Order No Item Number Date Driver Name 85629 A1234 9/21/2022 John Scenario 1 85629 B123 9/21/2022 John Scenario 1 85629 C1245 9/21/2022 John Scenario 1 85629 A1234 9/23/2022 Max Scenario 1 85629 B123 9/23/2022 Max Scenario 1 85629 C1245 9/23/2022 Max Scenario 1 85629 A1234 9/25/2022 Jose Scenario 1 85629 B123 9/25/2022 Jose Scenario 1 85629 C1245 9/25/2022 Jose Scenario 1 85629 A1234 9/26/2022 Carlos Scenario 1 68956 D-1898 9/26/2022 Steve Scenario 2 58694 F898 9/26/2022 Daniel Scenario 3 58694 F898 9/27/2022 Miguel Scenario 4 * Scenario's are not in original table used for explanation. Return Table: Order No Item Number Return Date Delivery Driver Name PickUp Driver Name 85629 A1234 9/23/2022 John Max Scenario 1 85629 B123 9/23/2022 John Max Scenario 1 85629 C1245 9/23/2022 John Max Scenario 1 69523 A1234 9/26/2022 Jose Carlos Scenario 2 68956 D-1898 9/26/2022 Steve Scenario 3 58694 F898 9/28/2022 Daniel Miguel Scenario 4 Thank you so much for your help. -Shashi amitchandak Greg_Deckler parry2k
