What! We don't need to learn DAX anymore? (New Power BI Feature)
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- Power BI has an exciting new feature that can "generate the DAX" for you. In this video, let me review the "Quick measure suggestions" feature. Using this, you can ask Power BI what you want to calculate in "natural language" and it will generate the necessary DAX code for you.
LEARN MORE DAX 👩🏼💻
==================
If you want to learn how to write DAX and analyze data easily, check out below videos.
Beginner to PRO DAX video - • Learn Power Pivot & DA...
How to set up Star Schema & Data Model in Power BI - • How to setup a Star Sc...
DAX & Power Pivot Playlist - • Different calculation ...
LEARN MORE POWER BI 💻💡
========================
My Power BI Course - chandoo.org/wp...
BOOK RECOMMENDATIONS 📚
==========================
Supercharge Power BI with DAX by Matt Allington - amzn.to/3HiPYEt
Definitive Guide to DAX by Marco Russo & Alberto Ferrari - amzn.to/3O9f4b6
#dax #ai
~
Have a beautiful day 😀🌻🌞
powerbi developers will do everthing but give better visuals
What the PowerBi team needs is some designers in their group
Two times in my developer life I used non-standard visuals. When I had to rebuild whole reports because visuals stop working with new update of PBI, I stopped using them.
ONLY provided with PBI.
I take pride in developing data calculations that make the most of the vanilla visualisations. You can also create your own in Python and many other platforms.
And return the dark theme
To be fair most stakeholders will just ask you to export what you've made in a spreadsheet or a ppt.
The problem with this is that simple measures we can do ourselves. What would be really interesting is making mid to high complexity ones. The feature may point a direction, but the way it is now it's more of a hinder to newcomers
Obviously it can't do any complex measures. Perhaps in few years when AI is more powerful
Was thinking the same. I wish my end users asked simple stuff like this
If you need very sofisticated measure you should re-think your logic. You should be able to split Everything to small simple steps.
Even sent rocket to Mars based on '1+1', ' 2x3' and etc :)
Use ChatGPT instead.
I'm keeping all my DAX books, the time old saying of garbage in garbage out will always apply when it comes to interacting with AI, computers & software. The Technical knowledge will always make you useful no matter the improvements in AI. Nothing beats understanding the concepts
0:16 I have those 3 books as well LOL. reading books is the way to learn DAX from zero to hero. I watched a lot of videos before and it didn't help me much untill I purchased some books and read from cover to cover.
Thank you. I use PBi just sometimes and it's good that I found out this through your video. It's a very useful feature.
I like the last scene when you picked your DAX books again
Started Learning DAX about 20 minutes ago and here we go🙂
🤣
You still have to learn it
Watch full video you will understand you need to continue your DAX learning journey 😂😂😂
Same here 😂
Same 😄
Hello Chandoo Sir thanks for your knowledge i have one query in his feature - when I gave command to POWER BI in settings as you said in this video, I'm not able to use it, it is showing that - "Either your admin has stopped you or you are using Live connected model". kindly help me with this problem so that i can make benefit out of it.
4 days after this is posted and there is not an option for quick measure suggestions in settings as a free PBI user. Have they moved this feature to be exclusive to premium users or have they taken it out to debug it?
True. But it still helps to learn the basics the traditional way. Then the feature can help.. Also Chat GPT or even the old good GOOGLE
Thanks for this video but we can not go with it without learning DAX because we need DAX knowledge to understand the calculation.
Thanks Chandoo. This was indeed helpful. Any suggestions on how to pull together a comet chart in Power BI? Thanks in advance.
You’re rockin’ it Chandoo! 🙏🏼
Love the whole powerBI aspect, my challenge as you stated is learning DAX but taking it slowly.
Stop learning DAX. Start build reports you want and then learn by using them.
Waiting for Microsoft to implement ChatGPT in it's software, then it would've not only make dax easy to use but also vba and power quarries like a piece of cake.
What about when we have multiple tables connected? When we have a lookup tables and fact table, how is it going to work? Example explained for one table exisiting
Dax is fun to learn and if u dont underdtand dax how you will ask questions ⁉️
We always have to apply the filters in excel for same dataset because from there we will be sure if the Ai have generated the right value or not . Lets take my case as I was creating this Churing rate in PowerBI BUT just to be sure that the Dax formula is showing correct calculation , I had my excel opened with some filters just to see if I am getting the same excel result in power Bi .
Simple measures has been around already, and most of your examples were fairly basic. I would want to know if it's capable of advanced time-series calculations with CALCULATE, FILTER etc.. will test myself!
Hi Chandoo,
Can you please create a video on "how to add comment at dashboard level & that communicate back to raw data"
I heard that it is possible through PowerApps.
If you don't know what you're doing, you don't know what you're doing. haha... Good video. AI is already everywhere and it helps don't get me wrong, but you still need a brain to know what you're asking, what you're expecting, you need to know how to perform validation, etc... We shouldn't underestimate learning and going through the process ourselves.
That is true. One needs to know what he or she wants. Contrary to this is like having many ladders piled on each other inside a deep hole. They won't help you out of the hole since they are stacked on each other flat on the ground. You just need one ladder propped against the hole's wall to climb out to safety.
Chandoo, unfortunately I too get a greyed-out Suggestions box. I am the admin, so I should be able to get access but I cannot. Can you please let me know if there is an easy fix to this issue?
Hi Chandoo
Please if possible can you give a link to your videos which explains dax from beginning to advanced which includes functions like
RANKX
SUMMARIZE
YTD, MTD etc and other complex functions..Also if the practice files are available it will be of immense help and learning
Even chatGPT is giving incorrect results sometimes.
We have to identify it and correct it.
These AI features are good still we need to know DAX properly.
This quick measure we can use when we want to save time and improve productivity...
Moral of the story is -
You should need to learn DAX to use such features...
how did you get that that (Microsoft Most Valuable Professional) hoodie?
Hello! Thanks for making such amazing videos. Could you please also show how to match up data from two different sheets. I am constantly getting errors or I don't know what I am doing wrong
Have you checked so that the relationships match up?
I don't want to talk down to you, but it does look like you might need a more fundamental understanding of how relationships work in data. I would look at "types of relationships in data science" and go from there, and then once you move back into power bi, understand that power bi works almost entirely with "one to many" relationships. That should be a good path for you to understand what's going on!
Thank you so much for this super useful video.
is this available in all versions or pro versions?
Chandoo, you mean to say that this will replace complicated DAX function in some way or other.
Hi
I've 4 years of experience in Data Analysis in the product Management in (Product Characteristics, categories) knowledge with MS Excel and Data Management Skills. I wish to upgrade myself to Power BI and something from my excel data management works to data visualization or presentation domain or something. Also I'm sure that I have enough skill to upgrade myself. But I'm clueless and helpless what I do next.
Kindly someone help me what I can do next for my career.
It is frustrating to learn a language and have it made redundant.
Truly, the only languages that haven't been a waste of my time were SQL and Python. I'm genuinely nervous about learning ANYTHING else in an in-depth level.
I am a new Power BI learner. What do you suggest. Should I only learn basics of DAX ?
This suggestion measures it only works when we give login credential, so in office, this was restricted from the admin can't use. So Chandoo having login credentials, so he was showing
Good video. I did learn from this video.
My Suggestions in Quick Measure is greyed out or disabled. When I hover over it states: Either your admin disabled the Q&A. However this is not the case - any suggestions. Thanks.
I doubt this will be able to calculate a rolling average correctly calculated across various factors which I found to be a complicated measure to implement. There was also nothing available online that worked for my purposes, so I had to piece it together.
I stuck in attrition% calculation in power bi. Could u please help with the separate video
For me suggestion option is not enabled it is showing Either your admin disabled(Q&&A) or you are using a live connected model
What's the title of the last DAX book you proposed to throw away... Didn't see the last one 🙈
Pst... I had only 3 books in my DAX library. But throwing 3 didn't produce a good shot. So, I snuck in a non-dax book in the middle to make the pile look bigger. Don't tell anyone 🤫
@@chandoo_ 😂
Hi Chandoo, Please can you give some ideas on making an inventory for stationery or ordering items.
You can find some dashboard about this on TH-cam
AI is upon us in an amazingly practical way. That said, it makes you wonder how many of those 10k folks that MS is laying off were DAX (or other code) developers they no longer need for internal projects?
That's an exciting idea, but the boring truth is most of the people in the 10K are likely related to the crazy hiring spree and project boom that happened during the last two pandemic years. Just look at MS/tech firms employee growth from 2019 to 2022. They're being cut loose here
@@Blashmack a lot of senior members were also let go with 10yrs + MS experience doesn’t mean they were hired during the pandemic. They were fired because they are no longer relevant to the current AI disruption. Majority of the impact is AI related and MS started investing in ChatGPT and will eventually buy it out and integrate in all their MS products.
That means the whole IT industry (not just high tech) but IT professionals are gonna be impacted by this.
Hahaha do you really belive AI will help? Even if 90% of my customers DO NOT KNOW what they want? To ask AI you have to be very precise what you want. Otherwise you can get answer on question you didnt ask...
Thank you so much for this valuable information.
thanks for the video!
Really helpful!
Chandoo from NZ is more cool than normal Chandu here. Thank you for the all the wisdom.:)
In PowerPivot Dax will remove it or not?
Hi Chandoo, I have installed Sep 2022 Desktop but I don't see preview features under options and settings..the same can see in my personal lap.. what could be the reason?
It is in the Jan 2023 version.
Hi, this is very important, please help. I have name, gender, and below critaria,
1. Name starting with same letter Should not be in a row (ex: raju, rajesh, geeta is wrong but raju, geeta, rajesh is correct)
2. More than 3 females should not be there in a group
With this critaria, for given data auto number should generated like group number and sl no within group. If this is possible with rank formula? Please suggest.
Thanks in advance.
In background, chatgpt or github co pilot like language models running for these features ?
I am sure it is.
Please can you provide one more project with new features of power bi without Dax formula and do it in a smart way
Thank you chandoo sir i like all your videos
Dude you helped big time 👌✨🌙⭐
Nice video. It would improve gradually.
I will look at your Dax lectures.
I plan to take pl300 soon intend to provide consultancy.
its like google spreadsheet ... in that also we get these sort of suggestions.
The copilot(suggestions) tab is disabled in my power BI. How to enable it? Pls help
Thank you for the video! I am new to Power BI, and DAX has really made me sad. This is such a great help!
I have a MacBook Air M1 and I have seen POWER BI installation is a very difficult. Kindly suggest me how can I install it in my Macbook for practice !!!!!!!!!
on a Windows VM through Parallels.
Wow Thank you Mr. Chandoo ❤
Love you brother ❤
Unable to open suggestions tab and not getting email id. please suggest
Thank you
Hello Sir
How we can get power bi work from freelancing. Plese make a video on it.
Million thanks
Thank you so much
Pls tell us about AI and data analysis
Does this new feature uses chatgpt over here ?
This has something to do with gpt from open ai?
Now people who know dax will be asked to fix autogenerated code rather than noob code.
Great news
Very helpful
The new feature still has some refining to go through.
Making money is an art, you can only make money if you practice and master the art..... by the way I enjoyed watching your videos. a fellow creator----
Are you giving training on Power BI?
I do.. see chandoo.org/wp/power-bi-course for my program and to sign up.
What is the version of this power Bi
It test your ability to ask questions. Practice framing the questions will greatly improve performance. This feature and similar AI features will very quicky improve A LOT!!
I think ChatGPT's AI is playing a vital role here as well ;)
What is chatgpt ?
@@noobgodyt Chat GPT is open AI tool.
Microsoft Azure will integrate Chartgpt....today they announced
Can also be GitHub co-pilot too , since Microsoft owns Github
Maybe an earlier GPT. GPT3 (what ChatGPT is based on) will can provide description and define a who Dax function based on your description of the data and your requirement . It's too good
Awesome! 😆
When Microsoft or anyone wants to dumb down and offer 'no code' I shudder and get suspicious. What happens when you need advanced features and Power BI isn't behaving the way you want it? I get for new users and for simple functions, but sometimes based on user feedback we have to do something advanced.
1 no. 😎🌟🌟
Thank the Lord for that! ❤
I dont have this feature in preview
May be we should use write way of questioning AI
Prompt Engineering.....Same thing works here.
"Suggestions" is not available for all Regions !
even it was enabled it was not working, not supported showing advance software also
Nice plot twist at the end...
I have really got afraid about this AI thing...all the bosses will take advantage of this feature and put pressure on developers. But after watching end of the video...I feel proud about developers.
Super Anna
Impressive
Thank You Sir for Posting this Video I am getting window of quick measure like yours but suggestion is disabled...can you help me.. thank You
DAX is brutal can’t wait for AI, text to code.
Lol that photo 😂😂😂
Fantastic
One dislike for the way chandoo throws the book to look cool.
Even if you don't see any learning from a book, you can't disrespect.
Mate.. just relax. If you watch it to the end you will see more.
Hi chandoo, I am working as a data analyst. At correct position I use SQL, excel ,power query, and just export the datasets from PBI reports. I want to GET A JOB as a PBI analyst. How to get a job without experience in PBI?
I was excited when he threw away the book only to watch the ending😂
nice
It's like ask data feature in Tableau.
Microsoft - Owns Power BI
ChatGPT - Microsoft just pumped $10bn into it. This will be interesting.
Wow!!
Really nice now DAX easy for guys like me but have one doubt what should have to write for more complex dax
Hii chandoo I have 4gb configured laptop, can I start power bi with that??
Yes brother but it might take some time loading depending on the processer