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.
So in my model i have my order tabel,
where i have an EmployeeID in colunms like
PickedBy
ShippedBy
ControlledBy etc.
I then have an employee table with information like the ID, name etc. that i have related on the employeeid to each and every column where it could be relevant throuh inactive relationships.
When i try to create a column on the orders tabel that includes the name from the related table I can only get it to work on 1 column, the rest i get
Essentially i created the "ShipmentBy" measure first and that one totally works. When i try to make new calculated columns I get this circular dependency error.
Here is the shipment by column that works.
Hi @AlexaderMilland ,
This error by creating calculated colum?,Why not try with measure?
If you do have the error with creating a calculated colum, you could have a reference of this similar thread which has been solved.
If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to public link. Do mask sensitive data before uploading.)
Best Regards
Lucien
Couldn't see a solution in the posted example. I've attached a link to a google drive containing a sample data.
Basically on the order table i want the Partner Name columns on each version. I can only get 1 of the 3 calculated columns to work (the first one)
.https://drive.google.com/file/d/1DA0AVhokYtpDas-UJrZUQGC9baySSa4B/view?usp=sharing
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |