Filters based on content of other tables in Power BI - Unplugged #44

preview_player
Показать описание
How can you move a filter from one table to another without a relationship in Power BI? By using the DAX code shown in this unplugged video!


#unplugged
Рекомендации по теме
Комментарии
Автор

I would love to have Alberto over my shoulder watching while I write Dax so he can say "that is basically useless" every time I write something stupid.

barttrudeau
Автор

brilliant! Thank you so much 👏 nothing like the privilege of the DAX guru optimising your code!

goldwhispers
Автор

What a classic breakdown of the complex looking code into a simple yet functional one.
Creates the belief to not to get worried by long lines of code.
This was a nice deep sea dive.

pratikfutane
Автор

I am truly amazed by the way you reduced the code to just a few lines 🙌 I need your level of understanding while writing DAX 🎓

radhikamalani
Автор

I love the way you looking at coding and summarize them. great Job!

Bumffy
Автор

not sure I got what I want but definitely told me what I need to do. damn man

jomarisevilleja
Автор

It's great to see a return to the unplugged series. It was very much missed.

TheCraigie
Автор

Thanks for sharing with us all Vanessa!

mwaltercpa
Автор

Thank for the thorough and logical presentation, as usual!

rdg
Автор

Hi Alberto. Another great exposition :) Thanks for that. I always wait for your next vid. All I know about DAX (and I know much) I have learned from you (and Marco). This has helped me so much in my career. Thank you a million.

dariuszspiewak
Автор

I'm still translating DAX into SQL to help me understand.

If I were doing this in SQL, I would've created a subquery, or CTE as some folks like to call it, of those columns and then inner joined it to my fact table.

Great explanation. Thanks.

DeronHuskey
Автор

Super explained. I realy enjoyed watching. Thank you
I hope we will see some new unplug videos by end of year.

sarajvo
Автор

From this model, I understand that the expanded version of Target table should not reach the Date table because it is not 1 side of relationship, right? (it's many to many but one direction filter)

ThepExcel
Автор

I am so blessed to see this. Thanks a lot man.

juitwfj
Автор

Such an ellegant solution! Amazing video as always..

pro
Автор

This was like watching high-level performance by an athlete / stage performer / etc. Just amazing start to finish - subscribed and no doubt will continue following this channel - thanks and Happy New Year 2024 !

davidf
Автор

It's great to see how you think :-). Excellent video.

Dzidza
Автор

Thank you so much for the detailed explanation.
I have one question: Since the target has nothing to do with Date, shall we simply remove the relationship between the Target table and the Date table?

wmfexcel
Автор

very interesting; I recently had to face this problem but in a completely different context: having a *query* that filters for values from another table. It seems to me that the engine does some weird (weird: something I wouldn't expect) stuff like for example launching one query B for each item of table A (Generated by query A) rather than passing a list of items.
This problem is most commonly solved by merging tables but this doesn't/cannot work on huge datasets as the filtering/merge/join happens only after the data is pulled while me objective was to reduce the amount of rows pulled.

This forced me to create an intermediate query that generates a string containing a list of items I want to filter for:
Source = APEXDealIDs,
OutputString = "{""" & Text.Combine(Source, """, """) & """}"

and then to use it as a filter in an analysis services query as an argument:
Pipeline[Deal Id] IN "& #"APEXDealIDsIntoString (2)" & "

Trying to embed the intermediate query elsewhere had behaviors I'd love to understand like timing out after 600s of transfers at 300Mbps (when the complete pull of the original table completes within a minute). I definitely must be missing something of the nesting logic in Power Query's engine.

Alex_FR_IT
Автор

how do we lock table on last day data and chart reflecting past 10 days stacked line chart data for each element on the tABLE?

bakls