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

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