Debug DAX using Variables in Power BI
HTML-код
- Опубликовано: 22 май 2018
- In this video, Marco Russo, from SQL BI, joins Patrick to look at how you can debug DAX using variables in Power BI. Marco helps to break down a DAX measure and show how you can see the results as you build it up to find where the problem is.
SQL BI
sqlbi.com
DAX Formatter
www.daxformatter.com/
DAX Studio
www.sqlbi.com/tools/dax-studio/
LET'S CONNECT!
Marco Russo
/ marcorus
Guy in a Cube
-- guyinacube.com
-- / guyinacube
-- / guyinacube
-- Snapchat - guyinacube
-- / guyinacube
**Gear**
Check out my Tools page - guyinacube.com/tools/ #powerbi #guyinacube 
Наука
Wowww! With Marco Russo! Amazing content, Patrick!
Thanks for watching Karine! We will need to get Marco back sometime.
@@GuyInACube please do it :)
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.
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!
Posted 3 years ago but still relevant today. Thank you so much!
Awesome video! Brilliant to have Marco Russo on Guy in a Cube!
WOW! What a pleasant surprise. There is always something to learn from Marco Russo. Great video and great class.
Great seeing you guys team up and a great subject too. Thank you!
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!
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.
I'm assuming it would be really difficult to write, or the PBI Team, or SQLBI themselves would have done it by now.
?
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.
create an idea and people can vote on it? ideas.powerbi.com/forums/265200-power-bi-ideas
This is one of the best DAX videos I've ever seen...I'll be putting this to use immediately. Thank you!
I will start using variables in my DAX code as of today!!! Great video Patrick. Marco is the DAX master 👍
Excellent! Thanks for watching Javier! 👊
You guys are great together. Perfect tutorial and super useful.
Wow! Great video. Masterfully done. You guys "blew the ceiling away ...and the crowd calls out for more."
haha thanks Robert! We are looking at doing more like this. And to collaborate more with Marco and Alberto.
Just discovered your channel... awesome, can't wait to view the rest of your content!
Amazing lesson on debugging DAX with Marco
wow, this was an opening eyes content! oh man, I was Dax blind. thanks. You should do more videos of this kind
We agree Rafael! Happy to hear you learned something from it. Thanks for watching!
It is amazing This website
Another WOW from me :-) and thank you for bringing Marco!
Great debugging session. Thank you for sharing.
Great video Patrick & Marco
It's perfect!!!!! Create a Playlist!!!
Marco's knowww!!
Many Thanks Patrick and Marco. Indeed a great information on Debugging DAX.!!
I have just started to learn dax and I have found a great place to improve my skills! Thanks a lot guys!
Awesome! Love it. Welcome to the cube! 👊
We love Marco! I recommend getting one of their remote consulting packages and they will answer all of you DAX questions.
Where I could find them?
Awesome video - thanks guys for the tips on using variables.
Very helpful. Thanks for doing a video with Marco. Would love to see more videos with DAX tricks!
Brilliant!
Keep them coming
As would we :) Thanks for watching James!
Marco the king of DAX.
Great video.
Big👍up!
This guy is a DAX monster, way to go, Marco!
Yes he is. We love working with him!
Nice to see Marco
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....
Thanks for the feedback Alan! Marco is awesome! I put those on the list :)
Great video and great learning
Thanks Patrick
Thank you guys for opening the door to a whole new world of better DAX'ing!
Just what I wanted to know. Thank you Patrick and Marco.
Great to hear! Thanks for watching Fran!
Love it! Thanks to both of you!
Great video, these "best practices" videos are very educational, especially for self-taught people! Applicable to all the reports I make...
Glad this hit home for you. We want to do more videos like this.
@@GuyInACube do we have a best practices playlist created?
Worked for me and changed the way I work with powerpivot now!!! Thanks!
Love it! Thanks for watching Hugo. 👊
awesome content.......Keep posting these kind of collab. very informational. :)
We love them too! 👊
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
Great learning tip for me today. You made my day folks
Woot! Glad to hear that. Thanks for watching! 👊
Nice, VAR and RETURN clear DAX.
Thank you, nice tips, nice session, and nice movie
This is very good. It's a much cleaner and structural approach. Thanks guys
Excellent! Most welcome. 👊
Great tutorial ! Thank you.
Thanks Marco. My concepts of using DAX are better now. I surely will have more questions when I start practicing
Awesome! Glad it was helpful. 👊
We love you guys!
Awesome Marco !
It is great brilliant!, You should do more videos of this kind..! Thanks
Patrick, I aggree with you: brilliant!
I aggggree too
👊
Wow! Absolutely brilliant!!
really really good video! keep 'em coming ;)
Still one of the best DAX video for me👍
good Job!
a debug object will be excellent to present all possible preview
Brilliant video!Good job!
Thanks for watching!
Incredible!!!... I will go back to the drawing board to map this as a high priority to learn more about. Thanks a lot for the eye opening!
Woot! Glad to hear it was useful for you Alejandro. 👊
Awesome video, big fan!
Thanks for watching!
It is very useful explanation. Thanks !
Glad it helped. Thanks for watching 👊
Great trick!...I am sure it will help many people in debugging process..
This is awesome thanks guys.
Most welcome! Thanks for watching!
What to say ? it's crystal clear !
Thanks Guys
Awesome, amazing as always!
Thanks Dan! very much appreciated. Are you going to be at Business Application Summit or PASS Summit? It has been a while.
The Marco Russo...Godfather of DAX
Great video!
Great. Thanks for the insight
You guys are to the point always. I appreciate it. Have you created a UDEMY training video? I would buy it.
Very, very, very useful. Thank you
Great Concept!!
Great! Thank you very mucho to you both.
So easy, but really effective! Like it
Amazing! Thanks!
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. :)
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.
Sei un maestro Marco!
Insightful info
Fantastic Guys!
Thanks Jose! Appreciate it.
I see Marco, I hit Like, simple as that... (haven't even finished watching the video).
Very useful, Thanks a lot!
Very welcome! Thanks for watching Michael!
Beautiful!
Awesome... thank u guys.. 🤟
Most welcome!
OMG DAX just clicked. This style makes SO much more sense!
Right?!? It is very awesome.
Thank u Patrick.🙏
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.
Thanks Anish! You can definitely use DAX Studio to evaluate the same measure. it lets you run DAX statements, so no reason it wouldn't work.
Very nice
GUYS you are champs par excellence
This is amazing
Wow! It is great brilliant!
Thanks for watching!
thanks guys!!! :)
Sic! Thank you!
Thank you
It is too cool, that i can use VBA/Excel expertise in Dax as well! , thanks for the amazing video and knowledge sharing. GIC
Love it!
Thankyou brilliant
One of the best videos this year
Amazing!!!!!
Essential viewing!
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!!
Amazing
Nice one.......
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?
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.
Marco is macho man of daxx....
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.
Cool
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
Pls do more videos on DAX pls pls.....