How to understand you are listening to an Italian person? You look more on speaker's hands than on speaker's face😂
@dailyuploads39592 күн бұрын
Great teacher, great mentor, great author
@mattelliott29404 күн бұрын
excellent resource! learned alot here. thanks.
@kebincui4 күн бұрын
👍❤
@kebincui4 күн бұрын
👍👍
@nikakalichava80125 күн бұрын
watched the video but did not really understand, does it help me solve the issue? was it in the video?
@SQLBIКүн бұрын
Look by yourself using the sample walkthrough: docs.daxoptimizer.com/introduction/sample-walkthrough/
@nehakhanna58935 күн бұрын
Need more of these !! ❤
@playingwithdio24215 күн бұрын
some of my brain cells suddenly connected with each other after listening to this explanation. Grazie!
@jagans64097 күн бұрын
Brilliant!!
@samanthapikus31787 күн бұрын
Love your white board explanations. Can you explain what you mean by, we say: Filter Columns and Iterate Columns not Tables?
@sumanshrestha98368 күн бұрын
Power pivot doesn't support tuple syntax. Is there any way around??
@SQLBI7 күн бұрын
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) )
@kopytko95588 күн бұрын
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.mutala9 күн бұрын
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.
@zeneto21579 күн бұрын
hello. a question raise. If the capacity of ram is excedded, can cause a buffer overflow and security issues ??
@SQLBI7 күн бұрын
No, the query simply fails, but no security concerns.
@trevorhardy904510 күн бұрын
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?
@SpokesPerson10110 күн бұрын
I’m genuinely impressed by the quality here-it's crazy it hasn't caught on more. Your editing and storytelling are spot-on.
@thorstenpesler847410 күн бұрын
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-pf6yg10 күн бұрын
Useful. Thank you.
@marcofestu10 күн бұрын
Ciao friends! Does anyone know what type of tool they are using for magnifying/drawing on the screen? Thanks in advance for any answer!
@SQLBI10 күн бұрын
We use ZoomIt (free Microsoft tool)
@andreashermle271610 күн бұрын
fantastic video, very advanced
@lmk00111 күн бұрын
As a visual learner its easier to grasp these concepts even though it probably takes you guys more time. Very helpful
@wmcnabb11 күн бұрын
Once again, you explain what is sometimes not so obvious. Thank you sir.
@gurvindersingharora530111 күн бұрын
Hello please upload more detailed videos about ALL and ALLSELECTED DAX.
@hannahiara11 күн бұрын
I’ll stick to the cat videos and also to you guys. And thank you
@sayananalytics344512 күн бұрын
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
@elliotyip984412 күн бұрын
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.
@SomeGuyInBrisVegas12 күн бұрын
Great!
@SomeGuyInBrisVegas12 күн бұрын
Wow. Great. You have saved me so much time and embarrassment. And again you seem to be doing videos just for me. 🙂
@thanhhang848812 күн бұрын
thanks so much I have been searching for a whole week
@patrickharilantoraherinjat299412 күн бұрын
like it. thanks
@Milhouse77BS12 күн бұрын
No, thank you 😂
@Milhouse77BS13 күн бұрын
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.
@SQLBI11 күн бұрын
For a simple case it makes sense. In real-world models when an entity can have 10 dates, it could be not practical.
@abhijeetghosh2713 күн бұрын
Good example and nice demonstration. 😊👍
@louism.498014 күн бұрын
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!
@TRZMac13 күн бұрын
I made a similar comment on a previous DAX optimizer video too, the music makes it hard to focus on the explanation.
@RajenderKumar-r7y14 күн бұрын
Amazing Teachings sir !! Massive respect
@RajenderKumar-r7y14 күн бұрын
Having urge to attend that Optimizing Dax course but it's too expensive for me
@praveensahni554714 күн бұрын
Is there any way to make FP in ssas tabular model ?
@SQLBI13 күн бұрын
It's a Power BI feature only.
@sp33d_boat14 күн бұрын
I didnt know I needed this.... but I did. So... thank you!
@RobertoStaltari16 күн бұрын
Learning DAX is like going down a rabbit hole: engrossing, time-consuming, yet exciting. Thank you, Marco.
@teigenxayden16 күн бұрын
You and your parttener are my favourates ,thank u a lot!
@ezscootrr16 күн бұрын
Chatgpt 01 preview helps me a lot with advanced use cases. My manager still doesn't how I was able to pull it off. 😂
@sherifffruitfly16 күн бұрын
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!!❤
@SQLBI16 күн бұрын
G R E A T !!!
@Ahmed-e4w1e17 күн бұрын
You are the best
@Ahmed-e4w1e17 күн бұрын
You and Alberto are my favorite dax heros
@tanwilliam735117 күн бұрын
The Article and download link are NOT working.
@SQLBI16 күн бұрын
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-e4w1e17 күн бұрын
Thanks Alberto I ve a simple question, does using variables a good thing in terms of optimization and speed? Thanks
@pablomiguez273317 күн бұрын
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-c3v17 күн бұрын
Just when you think you're starting to get a grasp on DAX, this is the place that will humble you.
@ivangennaro548417 күн бұрын
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.
@Waterloo202117 күн бұрын
Can’t use it in calculated column, only in measure