Forum Discussion

renatopnovaes's avatar
renatopnovaes
Icon for Helper I rankHelper I
5 years ago
Solved

Check another table

I'm setting up a conference between two tables. The target table and the sales table. I did a merge, I was able to say if the goal was completed or not. But if the seller sells the same product one m...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    As SELLOUT_D is your right table, in your join step, you can surround SELLOUT_D like this:

     

    Table.NestedJoin(#"Metas Julho", {"CLIENTE", "PRODUCTO"}, Table.Distinct(SELLOUT_D, {"CODIGO", BASE_SKU_GRUPO"}), {"CODIGO", BASE_SKU_GRUPO"}, "SELLOUT_D", JoinKind.LeftOuter)

     

    --Nate

renatopnovaes's avatar
renatopnovaes
Icon for Helper I rankHelper I
5 years ago

Yes, I merged. This image below merged the goals and added the sales. But when a customer repeats the purchase of a product from the target, it would double...

After fusion and duplicate sells

 

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.