Forum Discussion

Naveennegi119's avatar
Naveennegi119
Helper III
7 years ago
Solved

match data

Hi All,   download power bi file link:- https://drive.google.com/file/d/1VyzLTsDMqCvo6JpQcKprJKCxoDLgMTqD/view?usp=sharing   let me explain what is the problem Now you see image when I sel...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Naveennegi119

    Check your relationship between Emp to MonthData and change it from Single to Both(See the screenshot).

    Hope this will help you!!!

  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Naveennegi119,

     

    Please use this formula instead. 

    Column =
LOOKUPVALUE (
    Empdata[Weekname],
    Empdata[Weekname], MonthData[Weekname],
    Empdata[EmP], MonthData[EmP]
)

    match_data

    Best Regards,
    Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Naveennegi119

Check your relationship between Emp to MonthData and change it from Single to Both(See the screenshot).

Hope this will help you!!!

  • Naveennegi119's avatar
    Naveennegi119
    Helper III
    7 years ago

    Hi Anonymous,

     

    I have many relationship in my power bi file. both side relationship already relate with data.  So it's occuring error.

     

    but thanks to reply and help.

     

    I try to figure out your solution work for me.

     

     

    Best Regards,

    NICK

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Naveennegi119

      I have created both side relationship and it's working fine with your data. See the pbix file for more details.

      Download pbix file

       

      • Naveennegi119's avatar
        Naveennegi119
        Helper III
        7 years ago

        Hi Anonymous,

         

        I know ur solution(what you are trying to teach me). but I can't use it my power bi file because there are already both side relation in my power bi file. I share only the data where I stuck.

         

        Best regards,

        NICK