Lookup multiple values in DAX

[@ivanovdmitry770]

Fantastic experience! With best wishes in New Year from Russia!!!

[@SQLBI]

Thanks - Happy New Year too!

[@TRZMac]

I am now 21 and I started learning DAX one year ago when I was 20, I really hope to be at your level one day, you are literally what I look forward to be!

[@franciscoclaudio4818]

I am Brazilian and I love the classes, an absurd command of the DAX language, it really is at a spectacular level.

[@adityakalra7383]

Thank a Lot! I was actually stucked from past 2 days on Lookup Value, with Generate and your video was just on time for me. Thanks really appreciate your videos & knowledge I gain from them. Chaoo friends ;)

[@Bharath_PBI]

This video introduces more DAX functions, but the main take away is to know which works best after doing a test.. !!

[@ЕвгенийСкляров-б3ч]

It`s a kind of magic!

[@micahdail]

Reasons this is amazing: 1. I don't do the tablify-a-single-value hack enough, and this video is a good reminder that it exists. (14:20) 2. The quick tip on breaking lineage of strings and numbers is gold. (19:50) 3. Alberto 'Do-it-in-a-single-take' Ferrari delivers once again. Who needs video editing software when you've got Alberto on the case!?

[@SQLBI]

We still use video editing for some cleanup, but we're not video makers, so we try to optimize by running a single shot when we can! :)

[@lanasedayanoch]

mind-blowing. Alberto you are fantastic coach, the delivery pace and style is superb

[@davidirias3459]

you make worth every cent invested in your Video Courses and outstanding with this youtube video.!!!!

[@smartwork4768]

Thank you Sir I am your biggest friend and leaned lots of things from you. Also I have enrolled both of the free courses on SQLBI.COM.

[@clementejosemartinezserpas6335]

Amazing work. Multiple solutions to a single problem. Thanks.

[@bpremchand93]

Very informative video 😊👍👍

[@gruffalocrumble494]

Great video, thank you. Instant subscriber :)

[@soumikmishra7288]

Wow, thats an amazing video. Learned a lot!!! Thanks

[@josemadrid4343]

These videos are very helpful. Keep them coming. Thank you.

[@yumyumhotsauce1]

enjoying this channel alot! very useful use cases. thank you!

[@zenomas4493]

You never fail to make me enjoy DAX. you nail it again. Thanks for ways to DAXing.

[@hakim4000]

Alberto you are always the best

[@sonetmollick4630]

Super amazing and I learned a lot.

[@zeisslaimen1]

thank you, Alberto :)

[@1yyymmmddd]

Great stuff ! Thank you. 👍

[@김차수-k2u]

Amazing and very deep training

[@Hettic]

Thanks Alberto!

[@reneglaus2476]

Again, greate thank you

[@brenoneto1050]

Good afternoon! Mestre Alberto your videos help a lot... high level, i do not work in the area, but, I have a lot of desire, I'm trying to create a report that shows me the margin of Good afternoon! Master Alberto your videos help a lot... high level, i do not work in the area, but, I have a lot of desire, I'm trying to create a report that shows me the company's margin based on sales and prices set by the company to check how much is being granted discount and onerando the margin. But, I tried to make measures to make these calculations ran on the desktop but not in the service, I decided to merge the sales table, with the prices and taxes of the price list and the recomposition paid by suppliers of another table in a single table ... it worked, but I can not but use the power query because it takes a long ... with your video I managed to join 2 (queries)tables and the measurements ran very well, but, you can tell me how do I insert another query, to consolidate the 3. very grateful.company based on sales and prices set by the company to check how much is being granted discount and offsizing the margin. But, I tried to make measures to make these calculations ran on the desktop but not in the service, I decided to merge the sales table, with the prices and taxes of the price list and the recomposition paid by suppliers of another table in a single table ...it worked, but I can not but use the power query because it takes a long ... with your video I managed to join 2 (queries)tables and the measurements ran very well, but, you can tell me how do I insert another query, to consolidate the 3. very grateful.

[@kingparc]

Thank you very much Alberto. I have a question, if we want to do the same with a measure to add it to the table "Sales" in the report, how can we change the script in order to return a single value?

[@SQLBI]

If you need a single value you probably can use LOOKUPVALUE, if you want to display multiple metrics in a single measure result, you have to create a string combining the results using COMBINEVALUES

[@kingparc]

@@SQLBI ok, thank you guys

[@satellitepop]

Marco, I have a table that has 1 column with de document and other column with doc_substitute, how is the better way to join this table with itself using document in the first table and doc_substitute in the second table ?

[@br31woodlands69]

Genius!!!

[@lukeminikoski]

Happy new year!!!

[@nikunjpatel7469]

Can we used table variable inside Generate function?

[@franciscoclaudio4818]

Is it possible in the same code to bring two columns from two different tables? Example: adding a column from the product table and another from the supplier to the sales table.

[@SQLBI]

It depends. You can read the value from columns in different tables (it's one of the examples in the article, follow the link in the description), but in terms of "search" it's not clear what the meaning would be...

[@BernatAgulloRosello]

The question may be why the two tables do not have a connection in the model in the first place using calculated columns 😁 just kidding, sure the use case will arise soon

[@SQLBI]

Sometimes you cannot - it is not common, but you could have a lookup table using Product Category and Year to get a discount. Just an example, if you can use regular relationships, it's always better!

[@juansepowerplatform]

thanks for the video, lots of good fundamentals applied here. On an import situation I would much rather user PQ to join the tables and just load one combined table. Thank you. Happy new years

[@SQLBI]

Of course - this technique should not be used daily, but when you need it (and maybe you cannot use Power Query - for example, you use a live connection...) it's there!

[@daoyanjin1727]

Thank you for the nice content. I would like to ask if I can use 'summarizecolumns' instead of 'selectcolumns' in the example used in this video? When is it better to use one function against the other?

[@SQLBI]

SUMMARIZECOLUMNS performs both GROUP BY and remove duplicated values, whereas SELECTCOLUMNS does not affect the cardinality of the table source and does not perform any grouping.

[@khalidb.6604]

Thanks a lot! If I have a date table and a product table linked to both sales and promo tables, does this help to solve the same issue and compute the query faster?

[@SQLBI]

If you can rely on regular relationships, you don't really have to use this technique - which is useful when a regular relationship cannot be used.

[@revenge9431]

Did your team make dax studio?

[@marcorusso7472]

I am a contributor to DAX Studio, Darren Gosbell (MVP) is the maintainer and main contributor: github.com/DaxStudio/DaxStudio/graphs/contributors

[@SQLBI]

We are contributors to the open source project.

[@vishalnasre1251]

Sir please make one video on how to follow your whole playlist to learn DAX in dept.

[@SQLBI]

Start from Introducing DAX: www.sqlbi.com/p/introducing-dax-video-course/

[@vishalnasre1251]

@@SQLBI thanks