Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, Sales and locations tables have relation as you see. But why when I add the District column to Sales table through Related command I get the following?
Solved! Go to Solution.
Hi @koorosh jan
Can you add samples of your tables here?
You can use LOOKUPVALUE code rather than RELATED to create a District column, see the below link:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
Hi @koorosh jan
Can you add samples of your tables here?
You can use LOOKUPVALUE code rather than RELATED to create a District column, see the below link:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
Hi Vahid Khan, The Related works correctly. Thanks for your attention.
Eradat
Koorosh@parsehtech.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
87 | |
61 |