Forum Discussion
Solved
Adding missing records in table, extracted from another table
Hi, I have a dataset, where in 1 original table (Name variant) records were deleted by user. How can I add the records with information from another table? Extra question regarding this, see...
Hi Satch ,
Based on your description, you can create a new "Variant" table to replace the former one.
New_variant =
var x1=SUMMARIZE(FILTER('Orderline',[Itemcode]="B"),Orderline[VariantId],Orderline[Description],Orderline[Itemcode],Orderline[costprice])
return
UNION(x1,Variant)Result:For Q2, not very clear to me. You can also create a new "Product" table using the same method and Re-establish the relationships between the four tables (mainly the relationships between the Product, Variant and Orderline tables)Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Satch ,
I think it might be easier and faster if you modify it at the data source.
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Yuna