Forum Discussion

sparkplug93751's avatar
sparkplug93751
Helper II
6 years ago

Relationships and Lookups

Hello,   I have one column that performs a lookup if another column matches criteria: if(category=30,"30",lookupvalue(table1(task),table1(category),task(category)   When I try and make a lookup (...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi sparkplug93751 ,

 

Would you please inform us more detailed information( your sample data(by OneDrive for Business)) if possible? Then we will help you more correctly.

 

Based on your dax formula, I suggest you change it to:

 

 

Column = IF('task'[category] = "30","30",LOOKUPVALUE('table1'[task],'table1'[category],'task'[category])

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai