Two legends. This is one of the most educative and helpful tips for me. Trust me this video just changed my view of writing DAX for my entire life. Cool job Patrick and Marco.
We need a debugger in PBI Desktop, with a DAX Formatter, breakpoints (variables) and the ability to output the debugger to another screen just like in Visual Studio or SQL Management Studio. I have the privilige to know Marco, the PBI team should hear him, not only by his expertise, but also because of the massive feedback he gets from user all over the world.
pato lobos it is a road map after all. PBI team have feature selection that have to deploy on monthly basis. If you ask me we need more than ever intellisense on advanced power query editor.
Marco Russo and Patrick, you guys have opened up the horizon for so many of us non-CS trained professionals to just jump into the DAX bandwagon..thank you so much!
I began to watch this channel a few days ago, and I learned a lot. I tried to learn DAX from the Microsoft documentation and I understood it. DAX is pretty understandable when short. However, when complex enough, it becomes unreadable. And then this video, with great tips and ways of building your DAX code. I think the idea behind DAX was to permit users to calculate mesure in a line, with two or three other functions. It reminds me of python because in a way, if you are not following typing rules you won't be able to understand your own code. I will follow the convention you used in your video and create variable when needed. I will be able to write DAX code thanks to you. You are doing a great job. Thank you!
Loved having Marco Russo on the video...do one with him on DAX Studio and one on VertiPaq Analyzer. Need to learn DAX Studio and the VertiPaq Analyzer is is so cool but not well known....
Ohh man..this is near to magic..I was having the exact same scenario it took 25+seconds to load the table...after using variables it came down 3.5 Seconds . Thanks guys.. looking forward for more videos
Variables are awesome. They are especially useful for calculate statements to get in filter information that a calculate doesn't normally accept. Calculate + Filter is bad! Avoid where possible.
Amazing.. Most productive video that I have watched in recent times, I could use this in my daily DAX development. Thanks Marco!! I have a quick question though, can we debug or evaluate the same measure using DAX Studio ? For DAX formatting, I prefer DAX Studio than a website.
Patrick, I am assuming that you pretend that you did not know it to make this video. Anyways, it's a great video. Now I can pinpoint to this video instead of explain that concept myself. It is a great example. More like this please!! and Thank you, Macro. Your book is like a bible. :)
Can we calculate difference between two tasks "task text" column. One tasktext will referred as released date and other will be considered as Closed date. Need to calculate difference between release date and close date based on selection of two tasks in the same slicer.
Thanks a lot guys for sharing the amazing tricks and patterns for debugging dax and with the help of dax formatter how we can see the codes in a beautiful ways , Just one question over here which i wanted to know Can we assign colors to numbers in a variable . For example if I am selecting number 1 my dashboard color for specific segment will become green or red ...... Thanks in advance!!
Patrick and Marco, thank you for the great video! I use the DAX Formatter a lot and it makes my code look very professional, but more importantly, it helps with the debugging. Please check out SQLBI site or get your hands on "The Definitive Guide to DAX" book by Marco and Alberto, guaranteed to make you a DAX geek, or nerd.
Hi Guys In a Cube...I love your channel!! Quick question. I have a table (permissions table) that holds all my company hierarchy and user permission to specific regions based on the user's system loginID. Would you have a video that takes the computer's login ID and use it in a variable to filter data down? I want to use my permission table to implement security and filter data so users can only see data associated with the records they are assigned within my permissions table
Hi Patrik, I am a newbie in PowerBI. However, I think using variables are taking some extra memories. Is there any performance effect if we use multiple variables?