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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
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