Filter columns, not tables, in DAX
20:37
DAX Optimizer 1.2 - new features
12:42
100K Subscribers - Thank you!
2:18
Пікірлер
@sherifffruitfly
@sherifffruitfly 22 сағат бұрын
100% true.
@dotpy7928
@dotpy7928 2 күн бұрын
How to understand you are listening to an Italian person? You look more on speaker's hands than on speaker's face😂
@dailyuploads3959
@dailyuploads3959 2 күн бұрын
Great teacher, great mentor, great author
@mattelliott2940
@mattelliott2940 4 күн бұрын
excellent resource! learned alot here. thanks.
@kebincui
@kebincui 4 күн бұрын
👍❤
@kebincui
@kebincui 4 күн бұрын
👍👍
@nikakalichava8012
@nikakalichava8012 5 күн бұрын
watched the video but did not really understand, does it help me solve the issue? was it in the video?
@SQLBI
@SQLBI Күн бұрын
Look by yourself using the sample walkthrough: docs.daxoptimizer.com/introduction/sample-walkthrough/
@nehakhanna5893
@nehakhanna5893 5 күн бұрын
Need more of these !! ❤
@playingwithdio2421
@playingwithdio2421 5 күн бұрын
some of my brain cells suddenly connected with each other after listening to this explanation. Grazie!
@jagans6409
@jagans6409 7 күн бұрын
Brilliant!!
@samanthapikus3178
@samanthapikus3178 7 күн бұрын
Love your white board explanations. Can you explain what you mean by, we say: Filter Columns and Iterate Columns not Tables?
@sumanshrestha9836
@sumanshrestha9836 8 күн бұрын
Power pivot doesn't support tuple syntax. Is there any way around??
@SQLBI
@SQLBI 7 күн бұрын
A much longer syntax, instead of: ( t[col1], t[col2] ) IN { ( "ABC", 123 ), ( "DEF", 456 ) } you can write: FILTER ( ALL ( t[col1], t[col2] ), ( t[col1] = "ABC" && t[col2] = 123) || ( t[col1] = "DEF" && t[col2] = 456) )
@kopytko9558
@kopytko9558 8 күн бұрын
No idea what happened at the end, we had outer filter on color so let's say we're inazure context, and we say keepfilters (So we require still azure), and then we combine it with Black + Contoso... then how do we obtain any value if one product can't be both azure and black?
@hannes.mutala
@hannes.mutala 9 күн бұрын
Very good solution. Could i use this approach to show values from the first month of the selected year to selected month? For example choosing 2024 in year slicer and October in month slicer getting the values from January to October and show values in matrix visual, monts values in their own columns.
@zeneto2157
@zeneto2157 9 күн бұрын
hello. a question raise. If the capacity of ram is excedded, can cause a buffer overflow and security issues ??
@SQLBI
@SQLBI 7 күн бұрын
No, the query simply fails, but no security concerns.
@trevorhardy9045
@trevorhardy9045 10 күн бұрын
In the SELECTCOLUMNS example (at around 18:08 of the video), would it be necessary to include the Sales[Date] column in this table in order to access the filter/slicer on date? If no, I wonder why not? How would this virtual table be of any use if we cannot filter it by date?
@SpokesPerson101
@SpokesPerson101 10 күн бұрын
I’m genuinely impressed by the quality here-it's crazy it hasn't caught on more. Your editing and storytelling are spot-on.
@thorstenpesler8474
@thorstenpesler8474 10 күн бұрын
Ein super Tutorial - genau das was ich gesucht habe - endlich eine Antwort wie ich die Monate (Kurzform) in die richtige Reihenfolge sortiert bekomme -- Danke!
@JuanHernandez-pf6yg
@JuanHernandez-pf6yg 10 күн бұрын
Useful. Thank you.
@marcofestu
@marcofestu 10 күн бұрын
Ciao friends! Does anyone know what type of tool they are using for magnifying/drawing on the screen? Thanks in advance for any answer!
@SQLBI
@SQLBI 10 күн бұрын
We use ZoomIt (free Microsoft tool)
@andreashermle2716
@andreashermle2716 10 күн бұрын
fantastic video, very advanced
@lmk001
@lmk001 11 күн бұрын
As a visual learner its easier to grasp these concepts even though it probably takes you guys more time. Very helpful
@wmcnabb
@wmcnabb 11 күн бұрын
Once again, you explain what is sometimes not so obvious. Thank you sir.
@gurvindersingharora5301
@gurvindersingharora5301 11 күн бұрын
Hello please upload more detailed videos about ALL and ALLSELECTED DAX.
@hannahiara
@hannahiara 11 күн бұрын
I’ll stick to the cat videos and also to you guys. And thank you
@sayananalytics3445
@sayananalytics3445 12 күн бұрын
Hello Marco Please please do a video of visual representation of CALCULATE Rule. I know most of the rules have been covered here but please do a separate video. Please
@elliotyip9844
@elliotyip9844 12 күн бұрын
Alberto, your explanation is by far the best I've came across BECAUSE you explain things from the ground up, sharing what are the problems and why other ways are better.
@SomeGuyInBrisVegas
@SomeGuyInBrisVegas 12 күн бұрын
Great!
@SomeGuyInBrisVegas
@SomeGuyInBrisVegas 12 күн бұрын
Wow. Great. You have saved me so much time and embarrassment. And again you seem to be doing videos just for me. 🙂
@thanhhang8488
@thanhhang8488 12 күн бұрын
thanks so much I have been searching for a whole week
@patrickharilantoraherinjat2994
@patrickharilantoraherinjat2994 12 күн бұрын
like it. thanks
@Milhouse77BS
@Milhouse77BS 12 күн бұрын
No, thank you 😂
@Milhouse77BS
@Milhouse77BS 13 күн бұрын
I wonder if splitting Sales into two fact tables, as Chris Adamson might recommend, would be useful. One table for Orders (with Order Date), and another table for Deliveries (with Delivery Date0. Then there are no blank dates. And the Order Date could be copied over to the Deliveries table to calculate days elapsed between Order and Delivery.
@SQLBI
@SQLBI 11 күн бұрын
For a simple case it makes sense. In real-world models when an entity can have 10 dates, it could be not practical.
@abhijeetghosh27
@abhijeetghosh27 13 күн бұрын
Good example and nice demonstration. 😊👍
@louism.4980
@louism.4980 14 күн бұрын
Nice demonstration there, Marco! Not a fan of the background music as it is quite distracting, but that just might be me. I think if it is a bit fainter it wouldn't be an issue!
@TRZMac
@TRZMac 13 күн бұрын
I made a similar comment on a previous DAX optimizer video too, the music makes it hard to focus on the explanation.
@RajenderKumar-r7y
@RajenderKumar-r7y 14 күн бұрын
Amazing Teachings sir !! Massive respect
@RajenderKumar-r7y
@RajenderKumar-r7y 14 күн бұрын
Having urge to attend that Optimizing Dax course but it's too expensive for me
@praveensahni5547
@praveensahni5547 14 күн бұрын
Is there any way to make FP in ssas tabular model ?
@SQLBI
@SQLBI 13 күн бұрын
It's a Power BI feature only.
@sp33d_boat
@sp33d_boat 14 күн бұрын
I didnt know I needed this.... but I did. So... thank you!
@RobertoStaltari
@RobertoStaltari 16 күн бұрын
Learning DAX is like going down a rabbit hole: engrossing, time-consuming, yet exciting. Thank you, Marco.
@teigenxayden
@teigenxayden 16 күн бұрын
You and your parttener are my favourates ,thank u a lot!
@ezscootrr
@ezscootrr 16 күн бұрын
Chatgpt 01 preview helps me a lot with advanced use cases. My manager still doesn't how I was able to pull it off. 😂
@sherifffruitfly
@sherifffruitfly 16 күн бұрын
Attending your dax class in NYC like 7 or so years back jump-started me into Microsoft, and now starting my own company. So THANK YOU!!❤
@SQLBI
@SQLBI 16 күн бұрын
G R E A T !!!
@Ahmed-e4w1e
@Ahmed-e4w1e 17 күн бұрын
You are the best
@Ahmed-e4w1e
@Ahmed-e4w1e 17 күн бұрын
You and Alberto are my favorite dax heros
@tanwilliam7351
@tanwilliam7351 17 күн бұрын
The Article and download link are NOT working.
@SQLBI
@SQLBI 16 күн бұрын
How did you get access to this video? It should be Unlisted, the article is scheduled for December 3, 2024! Please come back after that date.
@Ahmed-e4w1e
@Ahmed-e4w1e 17 күн бұрын
Thanks Alberto I ve a simple question, does using variables a good thing in terms of optimization and speed? Thanks
@pablomiguez2733
@pablomiguez2733 17 күн бұрын
I have a similar problem. I want to show monthly data, only up to the last day. But biggest difference is that I have many variables, not just one (Sales in your example)...
@SYLDE-c3v
@SYLDE-c3v 17 күн бұрын
Just when you think you're starting to get a grasp on DAX, this is the place that will humble you.
@ivangennaro5484
@ivangennaro5484 17 күн бұрын
I have been struggling with DAX for quite a long time, but this video was absolutely GOLD. It just cleared my mind, bringing me the basics and fundamentals to understand what's really going on. Thank you.
@Waterloo2021
@Waterloo2021 17 күн бұрын
Can’t use it in calculated column, only in measure