I want a shirt that says, "I'm not lazy; I'm just really efficient." 😂
@hunterzayne2730
3 жыл бұрын
A tip : watch movies on Flixzone. I've been using it for watching all kinds of movies recently.
@jonathanlawrence2249
3 жыл бұрын
@Hunter Zayne Yup, I've been using flixzone} for since november myself :)
@danielnichols3594
3 жыл бұрын
I find it difficult to put a wrapper around the dax query table results to convert it back to a scalar value. But it's a great tool. There's just not a lot of resources explaining how to use Dax Studio effectively.
@Bharath_PBI
3 жыл бұрын
Yooo, This is what we do for every complex measure, and can't work without tabular editor and DAX studio. New version of DAX studio is released and looking at the enhancements of it.
@lauragidney-falk6148
3 жыл бұрын
Patrick, awesome video! Can you recommend a video that actually shows more on how use DAX Studio? I can see how this would be great to use but I am getting lost in the syntax...
@asjones987
3 жыл бұрын
Is that a Measure table for your measures? Don't let Marco see that :) Seriously I do struggle with DAX and there is a little bit of extra syntax for DAX Studio like EVALUATE and DEFINE other stuff. I noticed you put the EVALUATE at at the bottom, but in a recent video Alberto put it at the top. Pros/Cons?
@TimeHater420
3 жыл бұрын
Was anyone else aware that Lloyd Banks knew PowerBI? Lol jk , great video brother keep up the awesome work!
@krishnakantapanda6835
4 ай бұрын
Now, we have got the Dax Query view inside of Pbi desktop..which could efficiently do the same job...
@maguilar89
3 жыл бұрын
I love the new intro with lego's
@teamofsteve
3 жыл бұрын
How many producers???
@NoisexKillua
3 жыл бұрын
Great job showcasing DAX studio and that cheeky way of highlighting min sales with DAX, gonna have to steal that!
@guilhemdelorme9089
3 жыл бұрын
Thanks for the tip, I was used to juggle back and forth with the modelling view to debug my measures : this indeed looks far more efficient and convinced me to give DAX studio a try after all!
@hi55us2
3 жыл бұрын
Wow, amazing video. I was more amazed how you can feed the hex codes as a column in your data model to update the visual!
@blueguy12345
3 жыл бұрын
Yeah i really liked that. Didn't know taht was a thing ! I'm testing first think tomorrow !à
@oladaposorinola6216
3 жыл бұрын
This is Bananas!
@naveen200848
3 жыл бұрын
This is it.now i leart that after summarizing i can add calculations on top of it
@waynethurman2144
3 жыл бұрын
It is obvious that you know the topic well, but you make it more difficult to learn by going so fast for someone who is looking to learn from you!
@aahnajaiswal6527
8 ай бұрын
Hi, Can you help me with one scenario I have come across- I want to duplicate the rows based on flag column(which should mark duplicate/non-duplicate the ranked column ).this column should mark non-duplicate to the first instance of Rank and Duplicate to other instance of the same rank value.Please help!!
@W.Wallace73
Жыл бұрын
Understanding, the reason why it works in the tool and not in Power BI. How would be the correction of this formula: ADDCOLUMNS( SUMMARIZE( zendesk, zendesk[Requester], zendesk[Category], "TotalRequirements, CALCULATE( COUNTROWS(zendesk), ALLEXCEPT(zendesk, zendesk[Requester], zendesk[Category]), ALL(zendesk) ) ), "MaxRequirementsPerCategory", CALCULATE( MAXX( VALUES(zendesk[Requester]), [TotalRequirements] ), ALLEXCEPT(SUMMARIZE(zendesk, zendesk[Requester]), zendesk[Category]), ALL(zendesk) ) ) RETURN MAXX( FILTER( RequestersPerCategory, [TotalRequirements] = [MaxRequirementsPerCategory]] ), [TotalRequirements] )
@sirojiddinsobirov5508
3 жыл бұрын
This is REAL bananas!! I have not known that using DAX studio is so great! Thanks Patrick, you are the best!
@cspidermx
3 жыл бұрын
Been struggling with a measure for days, this video allowed me to solve my problem in under 4 hours. THANK YOU!
@jacobpadgett5218
3 жыл бұрын
Thanks so much for the demo! I'll have to get this now for my team! As always, best tutorials period. You rock.
@GaryMillerUK
Жыл бұрын
I didn't know you had to put DEFINE and EVALUATE around your DAX code in order to get it to run in DAXStudio. I gave up on it when the simplest code (a COUNT of a column) produced syntax error messages. The gui says to paste in code to begin. I don't have the time to invest is something so unintuitive.
@Milhouse77BS
3 жыл бұрын
And Tabular Editor, and ALM Toolkit :)
@Phoenixspin
3 жыл бұрын
Not sure I like Patrick pointing his finger at me in the thumbnail but the video was so helpful I forgave him.
@MrMarcusjames
3 ай бұрын
I learned so much thru this video! As a new user, it was an eye opener,
@javaughnfrancis1799
3 жыл бұрын
Awesome Video. However, highlighting a Bar dosn't work for me when I'm using a Live Connection but only when against my source data. Any suggestions? Haven't found any online.
@jimmy-k6770
3 жыл бұрын
Wow I can't able to install the software, very worst software
@Sideshowgaz5779
3 жыл бұрын
Logging a request with IT right now to have them install DAX studio on my image. Cheers Patrick
@kishoreyc
3 жыл бұрын
this piece of DAX code should go along with a larger visualization. DAX studio is great and i guess the users have explored the benefits of it only so much yet..
@YellingSecrets
Жыл бұрын
Just found you, subscribed! Excited to see more and go through previously posted videos!
@jefffischer7734
3 жыл бұрын
This is great stuff Patrick. Thanks for walking us through the use case!👍
@laurenceabrahams3996
2 жыл бұрын
Love this Dax Studio , brand new to this idea and need to learn from scratch the Dax studio bit best videos? thanks
@hermesjrd
3 жыл бұрын
Great Video Patrick, I'll be using DaxStudio from now on..Thx
@m4ttyc88
3 жыл бұрын
Can DAX Studio connect to a tabular SSAS model being used in PBIRS?
@rerangelt
3 жыл бұрын
In pwbi i write a measure x=1 and run ok. I write that in ds and get error. Add define and evaluatr nd get error. I dont see a user manual for ds. Its frustrating for us the new ones
@pabeader1941
3 жыл бұрын
Did you say 'rolling pin' on purpose? Just to see if I would say something...
@pabeader1941
3 жыл бұрын
You may have just converted me. I've been avoiding DAXStudio but I guess I'm going to have to take a second look.
@sue_bayes
3 жыл бұрын
love it, was pasting in something from DAX studio which gave me the exact same error message and realised it should be a table not a measure, duh me, thank you
@sravankumar1767
3 жыл бұрын
How can we write a color nor just in switch function . Could you please explain it..
@ahmeddaoui9965
3 жыл бұрын
Hi Patrick, thanks for this video. Quick question I am using SQL server and SharePoint as source of data. The issue is when i publish to power Bi service i am forced to use a gateway of my company. The thing here is there is a gateway configuration for SQL server but not for sharepoint. Is there any solution to bypass the fact that sharepoint also need to be configured in the gateway. Thanks again
@jorgesamuelgarciamorales6309
3 жыл бұрын
Do you have a course of DAX language, i'm interested
@theg9811
3 жыл бұрын
thanks patrick great job as normal. I'm using Dax Studio but this is another trick in the bag cheers
@shubhs2563
3 жыл бұрын
Thank you. Learnt something new. Will be using Dax studio
@silicatoss
3 жыл бұрын
Man... You're awesome! I am just starting to use DAX Studio and your video just showed me that I must hurry!
@DanielTavares29
3 жыл бұрын
Man!! First visualization 🤣🤣 Thanks for your tips! I am not used to Dax studio yet, but gonna try this approach 👍👍
@kasperjensen3113
3 жыл бұрын
Finally someone could explain in detail how to use DAX studio 🥳 Have so far only use the formatter.
@AshutoshDeshpandeOfficial
3 жыл бұрын
This video just convinced me to use Dax Studio. Thanks for great video. 😁😊😊
@MarioDiasJr
3 жыл бұрын
This video is a life saver. Whenever I get stuck, I go back to it and move on. Thanks Patrick!
@trinitxu
3 жыл бұрын
Another awesome video! I go bananas with the quality of your last videos
@petemurphy7164
3 жыл бұрын
thanks for this vid, really helpful..
@torsteinzahledvardsen8146
2 жыл бұрын
Thanks guys! This was very helpful☺☺
@paragkhandalkar
3 жыл бұрын
If we want to have it for our client, does that have cost?
@90s_HipHop
3 жыл бұрын
Quick side question - What's with the prefix @ on the columns names in your DAX? Is that a naming convention or does it serve another purpose?
@shetzel9722
2 жыл бұрын
I was wondering the same thing, do you know why yet?
@fabianabecatini6743
7 ай бұрын
it's very new to me, thanks
@aloysiusadrian5726
3 жыл бұрын
This is great. Can i edit existing column or measure in Dax Studio? So far, i have been copying from PBI desktop and pasteing into dax studio.
@ezekiel0606
2 жыл бұрын
link the dataset when you start
@Darknesslc3
3 жыл бұрын
great demo, btw im your 999th liker 👍
@saurabhgadre1
3 жыл бұрын
Thanks for new way to handle complex DAX :)
@roxanarodriguez1828
3 жыл бұрын
I mean such a beautifully way on detail every single detail, Fan #1
@EricaDyson
3 жыл бұрын
Even if I am a bit lazy, I still love to be efficient! Great. Thanks
@Trindade1988
3 жыл бұрын
Holy...this is just amazing !! Thanks a lot. Salute from Brasil
@sergiemotiev1817
3 жыл бұрын
Just a wow comment, thx
@giri41
3 жыл бұрын
How to install Dax studio please??
@kennethstanley7438
3 жыл бұрын
Thank you for the great instructions
@ponspons4345
3 жыл бұрын
Where can I find thus uses data?
@wallacefilipini5534
3 жыл бұрын
Congrats for translate to portuguese, thank you
@HafsaYAQOUBI
Жыл бұрын
Amazing video as always !
@ajaaskelainen
3 жыл бұрын
Just WoW, mindblowing! Thank you!
@williamleveson-gower5088
Жыл бұрын
I love it !! thank you.
@dzikoo
3 жыл бұрын
Why it is not build in PowerBI desktop?
@jessicajolly7828
3 жыл бұрын
I think his point was that sometimes you have to go back and forth when you are writing complex DAX. If you do it in Power BI, you are waiting for all the visuals to render on the page each time. Trust me--it's a time waster.
@CuddleStories
3 жыл бұрын
Will Smith!!
@yeraldo05
3 жыл бұрын
Damn Patrick, thanks a lot!!! I'm going to start using Dax Studio. This tool seems awesome and can save you a lot of time.
@vincenzo4259
2 жыл бұрын
Thanks
@adirozeri7162
Жыл бұрын
what?
@hamidsh4789
3 жыл бұрын
Excellent Thanks.
@sahiladya8473
3 жыл бұрын
Amazing
@isidrebague3659
3 жыл бұрын
GReat !!. Thanks !
@scfo
3 жыл бұрын
Wow...thanks man!
@arslanmix
3 жыл бұрын
Perfect
@nassaugustavo
3 жыл бұрын
Aewesome!!!!!
@huludShai
3 жыл бұрын
Noice!
@vxmine
3 жыл бұрын
Good vid Patrick!
@andyparkerson
3 жыл бұрын
Great stuff! Wish I had watched this video an hour ago when I started working on a particularly persnickety DAX measure.
Пікірлер: 88