Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Return data from diffrent tables

    Posted 16 days ago
    Hello,
    Need help ! I want to get the data of VMSTA_Distribution_chain_specific_material_status from the table gold_france_md_mrdr_salesorgchan for the the MATNR_Material_Number  from the table gold_france_md_mrdr.



    ------------------------------
    Younes HALLAI
    Apprentice data analyst
    ------------------------------


  • 2.  RE: Return data from diffrent tables

    Posted 12 days ago

    Hi Younes,

    With model you presented here you can't have what you want.
    Why?
    Because you have One-To-Many relation between those tables.
    If you pick one record from gold_france_md_mrdr table and you try find your record in gold_france_md_mrdr_salesorgchan you could get a few answers -> you get error, as PBI can not determine which one should use.

    At the end you should have ONE answer.

    Regards,



    ------------------------------
    Adam Artur Boltryk
    Business Analyst
    ------------------------------



  • 3.  RE: Return data from diffrent tables

    Posted 9 days ago
    Hello,
    Thank you for your response.
    Indeed I tried  with lookupvalue but I only have a few lines.
    Do you have an idea how to do it? Or is it just impossible?

    ------------------------------
    Younes HALLAI
    Apprentice data analyst
    ------------------------------