DAX Fridays! #90: Understanding LOOKUPVALUES error

Have you got the following error when using the DAX function LOOKUPVALUES? "A table of multiple values was supplied where a single value was expected" in this video, I will show you why that error happens and what you need to do to resolve it and use the function as intended. You dont know how to use the lookupvalue function? Here is a guide: https://curbal.com/blog/glossary/lookupvalue-dax Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU Link to DAX Fridays survey: http://bit.ly/2MMM4KK Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ************ ************ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP