Will Artificial Intelligence Make Learning DAX Obsolete? | Power BI
ฝัง
- เผยแพร่เมื่อ 23 มิ.ย. 2024
- 👉 Join our popular FREE Power BI QuickStart course today: link.xelplus.com/yt-d-AI-powe...
Microsoft introduced a new feature in Power BI that can suggest DAX formulas for you. You can ask for the DAX measure you need in natural language and artificial intelligence will write the DAX code for you. The AI used is OpenAI GPT-3. It's one of the first AI integrations of GPT-3 in the Microsoft applications. In this video we'll see how well this works. It's also important to test your DAX measures and also some scenarios you need to be aware of. So you'll have to currently "correct" the automatic DAX measures that are written for you.
✅ Boost Your Skills: Browse Our Courses ► www.xelplus.com/courses/
⭐ If you're ready to become a Power BI Pro, join our "Fast Track with Power BI" 👉 www.xelplus.com/course/fast-t...
00:00 No More Learning DAX
00:24 Important Settings for Quick Measure Suggestions
01:43 Why Use AI in Power BI
02:14 Simple Measures with AI
03:49 More Complex Measures
05:44 When AI in Power BI Fails
09:03 What to Watch Out For
13:02 My Conclusion about AI in Power BI
🎬 LINKS to related videos:
Should You Learn Power Bi? Everything You Need To Know: • Should You Learn Power...
How To Create these useful Power Bi Visuals that Excel Lacks: • How To Create these us...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#powerbi #ai #chatgpt
![พบรัก - INK WARUNTORN [Official MV]](http://i.ytimg.com/vi/n2wjOYVC38Y/mqdefault.jpg)
AI is cool, but mastering DAX is timeless. Want to stay ahead? Dive into our popular Power Pivot & DAX Course: link.xelplus.com/yt-c-AI-powerpivot-course or if you want to upskill and learn Power BI, join our FREE Power BI QuickStart course now: link.xelplus.com/yt-c-AI-powerbi-freecourse
Thanks 🙏
Yes
Thank you Leila for this introduction. Can help learn and understand complex DAX better, but I personally feel that, one has to manually learn and apply technology and use such tools for occasional quick solutions and enhancements, rather than as a substitute for the joy of understanding and applying by self...
Fully agree Vijay.
Thank you for this video! Can you do a training on how to filter/do a pivot table on a survey with multiple response option so that you can filter on the response to see what question is associated with it? Been working on this for days!
Awesome presentation! I LOVE the added animation! Will help me immensely..
Dear Leila
Thank you for an inspirational and well documented video, have not tried the AI tool yet, but see it as a great help. And for the question, will AI make learning obsolete? - that will be a big mistake leading to trust everything we see.
"AI" is beyond ... waaaaaaaay beyond, my pay grade at the moment. Nonetheless ... taking a peek into the future with you is always thought provoking ... and always appreciated.
Thank you ... thank you ... thank you ... 😍😍😍
excellent work. fantastic. learned a lot. thanks
Thanks Leila this is helpful understand, and DAX still need to learn!
Never noticed this Quick measure is having such wonderful things, thank you for sharing
Nicely explained. Thank you!
The best teacher in the World ❤. From Marocco, many thanks for all your videos.
I really love your videos . Thank you so much they help a lot to me as i'm currently trying to learn using power bi ☺
ROW CONTEXT, FILTER CONTEXT, CONTEXT TRANSITION, that's it!
learn THIS first in DAX, everything else falls where it should.
Thanks for the demo Leila. The upside is that more people will start using Power Bi. The downside is that fewer people will actually understand what they are doing, or trying to do.
The "smarter" that our apps and devices become, the "dumme??" the user become. My 10 year old ephew can use a calculator to multiply but is clueless to do so with a pencil and paper.
The calculator is an interesting example. I would probably struggle to do long division on paper but would argue that skill is pretty much useless at this point. But I agree the user is being given more & more interfaces between him & the computer, which has its downsides.
Exactly my thoughts. There will be some benefits, for sure, but I can't stop thinking about how AI is taking over the one thing that excites me - getting to solutions by myself. The process (in my case) is what motivates me...
Hello, I have a question
In excel 2021, the Khmer font in work sheet is pretty normal, but when I go to print the khmer font is cut off above. So what can i do?
Can it also comment out the dax code that it generates?
Thanks for posting this Video
Thank You! ❣️
I am running into the following error when trying to pivot a table in Power BI. Any idea what might be causing this and how to fix it? Thanks
Expression.Error: There weren't enough elements in the enumeration to complete the operation.
Details:
[List]
as a beginner in learning DAX, should I try this open AI feature?
or go through the "harder" way first? 😅
oh yes.. I purchased your DAX and Power BI course and going to start my Power BI journey
I would suggest learning the old fashioned way. Your future value will grow exponentially if you do...
Without knowing DAX you won’t know if the answer you’re getting is correct or how to tweak it, so it’s probably still worth it at this point
Try it but use it to actually learn the DAX patterns it suggests, and not to try to avoid doing your work. Best use is when you don’t know how to solve a problem, it are pretty sure it’s possible. A
If you start with very simple examples, you can Google the key functions and actually learn what the chatbot is suggesting and learn to apply it to your actual work situation. Always reference actual documentation online and actually learn DAX. Remember, ChatGPT doesn’t actually understand what it’s doing, it’s just suggesting the most likely solution based on the words in your prompt, so it will sometimes get things wrong.
i disagree i think this function is amazing! if you give it more context like telling it where the column are located and giving it more context it would give you the correct answer. With chat gpt i managed to get extremyle complicated measures, without it i could not get them in a lifetime
Hello,
I want to filter my table,choose only rows that in a [colonne comment] text contains a substring "test".
With DAX
Filter(my table, contains ([colonne comment],"test")).
This function give me an error.
Could you please help me to fix it.
Thanks in advance
Seems just as complicated as learning DAX with the added problem that it may or may not give us the results what we want. Once we learn to code things its a lot simpler to write out the code than to go through hoops learning the intricacies of this AI feature.
Hi Mam, in google sheet i want to replace - to zero what will the formula other ctrl+h. i am doing vlookup its coming - only
As usual you are great 😊
Love the way you explain it !
Hey Leila! What do you think of the new Bing update for Windows 11? Does it work? Is it safe? I trust your opinion.
OMG!!!! Leilaaaaa!!! you saved my life! What an amazing tip!!! hahahahaaha cool!!
Hello Leila ... I hope you are in good health ... plz if can answer me bout this question ... I have one client have windows 10 and office 2016 word documents after he saved the file ... on the D part .. then shut down the Pc ... when open the computer the file disappeared from the computer ... :( ... this every day ... and now he saves all file on an external drive
It needs to be smarter, needs improvement and if that is taken care by Microsoft it will be great
This is a great innovation that will democratize Power BI and empower a new class of users. Fantastic! Thanks.
I feel like AI is being forced into use cases it isn't good at. I equate it to rolling dice. If you aren't sure what restaurant or what menu item you want to eat, rolling dice is fine, it could lead to trying new food that you might enjoy, but if you're trying to generate an expense report, you don't roll dice to get your numbers. With AI, if you're trying to come up with a fictional story, it can give great ideas, but it's not so good at generating factual information.
Hi Leila,
Good evening.
A co-worker left the company and now I need to edit an APP that he is the owner of. I have to revise a few measures but I am not able to edit them. Options to download, etc are greyed out. Is there any solution to this case? Is there any application that I can use ?
BTW why is difficult level emoji so angry?
Because that's how DAX makes you feel most of the time 😅
really great
solution in perpetuity
Is this feature available for Power BI free?
Power bi is only one that is free application there no paid application
Powerbi desktop is a free to download app, so yes, there is also powerbi pro and premium that have a lot of extra features and those are paid
I think Product team released this just to meet their targets while doing not proper QA :)
SYNTAX ERROR
Mashaa Allah, quite OK
If it's AI, then it will learn and get better with time.
I want power bi ai tool
It's time to F5 my brain 🧠🧠
Hm. Yet again I find myself asking, "who" is benefitting from this? This "helper" requires a lot of my effort for scant / no material efficiency gain in my coding work. That's because this is really about teaching a machine how to replace me.
Is it just me or does it appear that all this AI is not really that helpful at all - you basically spend just as much time figuring out how to spoon feed it data OR you have to so thoroughly review what it created to ensure it is correct that it's not a replacement for knowing how to do it yourself.
Yes, it is just you. 😊
It's same as everything
The more you use it, the more you are used to it
And the more you can take ownership of it
It's just the beginning. Wait for it. In 2-3 years AI will do 90% of this.
It’s just you
I'd be more worried about peeps who use it to write code they don't understand, and especially with Dax that can be a problem for the user's. For the Dev fixing these none coder pieces is going to be a fun time :(
B A N A N A S !
Human learning of computer sandbox play as an education path to employment is now archaic. Probably as unnecessary as being able to work a cash register at retail jobs. If a computer can do this dreary thinking burnout work, I think it's a big win for humans. Who wants to do this computational garbage? No one, except the generations who were told "to get a good job, get a good education". That slogan was BS fifty years ago and it's even more BS today. Finally we can see the fruits of alien technologies that have been unseen since the 1940s. Jobs, in general , are a lost 20th century diversion for the masses. Let's all get back to dreaming, breathing, and living. Work is for robots.
If you're already wealthy enough to retire now, great, otherwise there will be no utopia for you. The best case scenario is that after a lot of hardship and civil unrest, governments eventually put everyone on a universal BASIC income, and we'll all get live a life of relative hardship and stunted freedoms. The profits from increased profit margins will be pocketed by those at the top of the corporations, and the disparity between the rich and poor will be greater than anything we've known. (And no, governments won't be able to force them distribute their profits through the population, they can't even get them to pay their taxes properly.)
It’s called a “report”, not a “re-port”
Madem, Some Problem on issue of formula please suggest me how to use in filter formula with hyperlink dynamically. Suppose When we Search formula ( =Filter(isnumber(Search())) this formula using but I want use when we search something on data in this table suddenly come with filter with hyperlink. Please Humbly Request solution we trying since 6 month but some issue facing. Please Suggest Madem 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏👈👈👈👈👈👈
I will be happy to help if you allow me.
What is your requirement what do u want to do