Forum Discussion

Satch's avatar
Satch
Helper III
5 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

Satch's avatar
Satch
Helper III
5 years ago

Thanks for this approach.

I not behind my PBI desktop now but will test this and let you know.

 

But how can I do this automatic for all missing records?
Since now it's filtered by Itemode B.

But there's a bunch of recs missing.

Is it possible to do for all missing recs?

 

Actually you answered Q2 also. what you're telling I was hoping for 🙂

 

Thanks!