What! We don't need to learn DAX anymore? (New Power BI Feature)

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/power-bi-play-...
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 😀🌻🌞

[@DGriffy0400]

powerbi developers will do everthing but give better visuals

[@mandovid]

What the PowerBi team needs is some designers in their group

[@xMastJedi]

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.

[@Acheiropoietos]

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.

[@saltesc]

And return the dark theme

[@BeastPriest98]

To be fair most stakeholders will just ask you to export what you've made in a spreadsheet or a ppt.

[@claudiozadorosny4722]

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

[@human_hope]

Obviously it can't do any complex measures. Perhaps in few years when AI is more powerful

[@photoo848]

Was thinking the same. I wish my end users asked simple stuff like this

[@xMastJedi]

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 :)

[@wcrayger]

Use ChatGPT instead.

[@loveyoutube22]

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.

[@Mahmoud-mf8hn]

thanks for the video! Really helpful!

[@usmanghulamnabi5425]

Thank you so much for this valuable information.

[@shivamaurya629]

I like the last scene when you picked your DAX books again

[@indus2059]

Thanks Chandoo. This was indeed helpful. Any suggestions on how to pull together a comet chart in Power BI? Thanks in advance.

[@Acheiropoietos]

You’re rockin’ it Chandoo! 🙏🏼

[@selinaakhter189]

Thank you so much for this super useful video.

[@francinagoh2541]

Good video. I did learn from this video.

[@Zhmenka]

Thank you for the video! I am new to Power BI, and DAX has really made me sad. This is such a great help!

[@boknows8263]

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.

[@chamodilaknadee1120]

Wow Thank you Mr. Chandoo ❤

[@marceljunioregondi5594]

Love the whole powerBI aspect, my challenge as you stated is learning DAX but taking it slowly.

[@xMastJedi]

Stop learning DAX. Start build reports you want and then learn by using them.

[@rabin3333]

Thank you chandoo sir i like all your videos

[@yogeshbansal7184]

Thank you so much

[@tasmisa6778]

Dude you helped big time 👌✨🌙⭐

[@MuhammadIrfanShaikhOfficial]

Very helpful

[@rakeshbr3926]

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

[@CriticalPotato]

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?

[@MrB-kd5ge]

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 .

[@ajithkumar-qw5rw]

Love you brother ❤

[@javedkhan-tz6fn]

Thanks for this video but we can not go with it without learning DAX because we need DAX knowledge to understand the calculation.

[@JunaidKhan-wg7cj]

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.

[@happyheart9431]

Million thanks

[@severtone263]

Thank you

[@The_1two3]

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.

[@rajeshm7337]

I stuck in attrition% calculation in power bi. Could u please help with the separate video

[@owenvbugiejohnbull4826]

is this available in all versions or pro versions?

[@muhsinkader3838]

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.

[@samirajput9351]

Started Learning DAX about 20 minutes ago and here we go🙂

[@SSM_33]

🤣

[@SSM_33]

You still have to learn it

[@Manjunath_pai]

Watch full video you will understand you need to continue your DAX learning journey 😂😂😂

[@Only-great-minds]

Same here 😂

[@Prasadiary]

Same 😄

[@NagendranathV]

For me suggestion option is not enabled it is showing Either your admin disabled(Q&&A) or you are using a live connected model

[@apamwamba]

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

[@shreevatsarao8177]

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

[@drew3030]

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.

[@iksharani175]

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

[@SvanbergSimon]

Have you checked so that the relationships match up?

[@dancorwin9232]

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!

[@BrianRAlex]

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!

[@MrSatyak]

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?

[@sagarrajput7377]

It is in the Jan 2023 version.

[@rohitsatpute3942]

how did you get that that (Microsoft Most Valuable Professional) hoodie?

[@ricoetbello]

Hi Chandoo, Please can you give some ideas on making an inventory for stationery or ordering items.

[@kaziabulhasib2849]

You can find some dashboard about this on KZbin

[@jayong2370]

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.

[@lightning369]

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.

[@limitededition2335]

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.

[@satyaramavath6512]

The copilot(suggestions) tab is disabled in my power BI. How to enable it? Pls help

[@michellebarnes7640]

Awesome! 😆

[@mdfoulds]

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?

[@kartikey92]

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.

[@mangeshkamble556]

Unable to open suggestions tab and not getting email id. please suggest

[@honeydelhivlogger8047]

1 no. 😎🌟🌟

[@felipebarrera3060]

This has something to do with gpt from open ai?

[@MisterWordExpert]

In PowerPivot Dax will remove it or not?

[@insidehead]

its like google spreadsheet ... in that also we get these sort of suggestions.

[@ashokuppalapati2688]

Super Anna

[@reemnasr1005]

Pls tell us about AI and data analysis

[@vinodgujja4268]

In background, chatgpt or github co pilot like language models running for these features ?

[@chandoo_]

I am sure it is.

[@AndrewJohnClive]

Thank the Lord for that! ❤

[@jeffbatista]

Impressive

[@harishmore7068]

Hello Sir How we can get power bi work from freelancing. Plese make a video on it.

[@Archon_Amit]

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 !!!!!!!!!

[@StephenSkoutas]

on a Windows VM through Parallels.

[@SiraSam]

I dont have this feature in preview

[@chinwee__o]

The new feature still has some refining to go through.

[@yousrymaarouf2931]

Fantastic

[@Navneey]

What is the version of this power Bi

[@raymondlee8951]

What's the title of the last DAX book you proposed to throw away... Didn't see the last one 🙈

[@chandoo_]

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 🤫

[@PranavPractical]

​@@chandoo_ 😂

[@SiraEkabutPlus]

Wow!!

[@SSM_33]

Dax is fun to learn and if u dont underdtand dax how you will ask questions ⁉️

[@vinodsoota1023]

Chandoo, you mean to say that this will replace complicated DAX function in some way or other.

[@randomguy4538]

Chandoo from NZ is more cool than normal Chandu here. Thank you for the all the wisdom.:)

[@Saruman00]

Nice plot twist at the end...

[@jasonmurray8777]

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?

[@Blashmack]

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

[@basictalent1]

@@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.

[@xMastJedi]

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...

[@manjotsingh4717]

Does this new feature uses chatgpt over here ?

[@reyniekaewkham8719]

nice

[@kartikeyshukla9181]

Prompt Engineering.....Same thing works here.

[@pgkannan]

Great news

[@user-ki6lu6od6n]

Please can you provide one more project with new features of power bi without Dax formula and do it in a smart way

[@gondalaprasad]

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.

[@sustainability.s]

Nice video. It would improve gradually. I will look at your Dax lectures. I plan to take pl300 soon intend to provide consultancy.

[@prudhvi5211]

even it was enabled it was not working, not supported showing advance software also

[@AntonioCarpioV]

Lol that photo 😂😂😂

[@soodvarun20]

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

[@sherifffruitfly]

Now people who know dax will be asked to fix autogenerated code rather than noob code.

[@manjutharak]

Are you giving training on Power BI?

[@chandoo_]

I do.. see chandoo.org/wp/power-bi-course for my program and to sign up.

[@inj1979]

Wow

[@xxczerxx]

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.

[@factshistory3193]

I am a new Power BI learner. What do you suggest. Should I only learn basics of DAX ?

[@dariochavez5751]

wow

[@yudapramana7040]

you always give valuable information, thanks

[@hayatibrahim4615]

But this feature is not free need to subcription and i tried to used but need comany email

[@picious]

"Suggestions" is not available for all Regions !

[@St8ofmind123456]

DAX is brutal can’t wait for AI, text to code.

[@YasinNabi]

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----

[@Seftehandle]

I feel like chatgpt in powerbi should bi in the title :)

[@chandoo_]

I also got the temptation, but refrained.

[@Seftehandle]

@@chandoo_ 😂 why not! It'such a good buzzword for clickbait yet somewhat correct

[@princemurali5509]

One of the great video

[@RK-wf7re]

It's like ask data feature in Tableau.

[@ganpathji]

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.

[@simonsmith8974]

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.

[@arbazahmad7177]

Absolutely right ✅️.... thanks 😊 for your recommendation...

[@keithmosaic3703]

I was excited when he threw away the book only to watch the ending😂

[@balamira297]

I think ChatGPT's AI is playing a vital role here as well ;)

[@noobgodyt]

What is chatgpt ?

[@techsaurav4987]

@@noobgodyt Chat GPT is open AI tool.

[@shrabannaik5927]

Microsoft Azure will integrate Chartgpt....today they announced

[@SKAMRANPASHA]

Can also be GitHub co-pilot too , since Microsoft owns Github

[@detourSixOne]

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

[@perfectionist6624]

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...

[@shankarbarai5653]

You are a great teacher man. Love from Bangladesh❤️

[@rccb-dineshprakash2956]

Great info boss