Тёмный

Introducing LOOKUPVALUE 

SQLBI
Подписаться 109 тыс.
Просмотров 23 тыс.
50% 1

Опубликовано:

 

2 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 25   
@SandipanSarkar-c8v
@SandipanSarkar-c8v 7 месяцев назад
Finished watching
@venkatareddykummitha5863
@venkatareddykummitha5863 2 года назад
It retrieves the value where product[product key] is identical to sales[product key]. or not identical explain a bit, please. But, in my opinion, it retrieves the value where matching is between [Search-columnName], [Search-Value].
@DIGITAL_COOKING
@DIGITAL_COOKING 4 года назад
Another awesome video i missed!! Great Alberto as usual 👍 Question please : can we sum values returned by lookupvalue instead of creating column
@SQLBI
@SQLBI 4 года назад
You can by using SUMX in a measure and using LOOKUPVALUE in the expression. Just be careful about performance!
@adityakalra7383
@adityakalra7383 3 года назад
All your videos clear my doubts on sub of DAX , Thanks
@stephanweaver1960
@stephanweaver1960 4 года назад
One can learn so much about a language from alternative ways of accomplishing something
@bandaralqahtani4356
@bandaralqahtani4356 2 года назад
If we already have a relationship between these two tables why do not we just add a calcualted column at least to get the same result , I think in this case no need to use "Lookupvalue", Am I right?
@SQLBI
@SQLBI 2 года назад
Of course, you don't need LOOKUPVALUE if you have a regular many-to-one relationship.
@papachoudhary5482
@papachoudhary5482 4 года назад
Thanks
@rrrprogram4704
@rrrprogram4704 4 года назад
Nice video
@AN-yo5zn
@AN-yo5zn 3 года назад
very useful, thanks!
@ephraimkizito8094
@ephraimkizito8094 3 года назад
I am creating a variable to use in a measure, and I want the variable to return a single value from a row of a table in my model. I cannot figure how to use lookupvalue insolving my problem.
@niavras
@niavras 4 года назад
Great video! Thank you!
@peterbogdanovich4043
@peterbogdanovich4043 3 года назад
Hi Alberto, I have a calculated column in my sales table. This column uses LOOKUPVALUE() to get data from Items table. If I refresh my item tables should the calculated column in Sales table refresh on its own? or do I need to refresh Sales Table too? Thank you so very much
@SQLBI
@SQLBI 3 года назад
The calculated column is automatically update when you refresh your item tables - you don't have to worry about that.
@LearnAtHomewithGulshan
@LearnAtHomewithGulshan 4 года назад
Nice
@AyoQuem
@AyoQuem 3 года назад
Thank you!!!!
@andreibulatov2395
@andreibulatov2395 4 года назад
Thank you! Very useful!
@eziola
@eziola 4 года назад
I didn't see the link to explain expanded tables that you pointed to in the video?
@SQLBI
@SQLBI 4 года назад
We added the link in the video description. Thanks for reporting it!
@albertoferrari6893
@albertoferrari6893 4 года назад
Here it is: www.sqlbi.com/articles/expanded-tables-in-dax/
@pravinupadhyay2046
@pravinupadhyay2046 4 года назад
I always think why we dont have a blank visual where we can directly put dax table expression, and then have the option to change that visual by any other appropriate visual as suitable to the table expression. Result.
@SQLBI
@SQLBI 4 года назад
The Power BI architecture doesn't allow to a visual to create the DAX query. The visual just receives data, the query is generated by the underlying infrastructure.
@pratikfutane8131
@pratikfutane8131 4 года назад
Great 👍
@diegoj9056
@diegoj9056 4 года назад
Thank you!
Далее
Differences between GROUPBY and SUMMARIZE
28:30
Просмотров 38 тыс.
Using RELATED and RELATEDTABLE in DAX
18:04
Просмотров 41 тыс.
Return Working Days in Power BI using DAX
16:28
Просмотров 8 тыс.
Understanding data lineage in DAX
18:14
Просмотров 30 тыс.
Lookup multiple values in DAX
22:10
Просмотров 52 тыс.
Introducing RANK window function in DAX
15:24
Просмотров 27 тыс.
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
Propagating filters using TREATAS in DAX
19:18
Просмотров 45 тыс.
When to use SUM and SUMX in DAX
15:48
Просмотров 25 тыс.
When to use KEEPFILTERS over iterators
18:56
Просмотров 48 тыс.