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

Подписаться 631 тыс.

Просмотров 208 тыс.

50% 1

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 😀🌻🌞

Наука

Опубликовано:

15 янв 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 175

@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

@The_Herniator Год назад

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

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

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

@indus2059 Год назад

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

@usmanghulamnabi5425 Год назад

Thank you so much for this valuable information.

@Mahmoud-mf8hn Год назад

thanks for the video! Really helpful!

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

@Acheiropoietos Год назад

You’re rockin’ it 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.

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

@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

@selinaakhter189 9 месяцев назад

Thank you so much for this super useful video.

@francinagoh2541 10 месяцев назад

Good video. I did learn from this video.

@chamodilaknadee1120 Год назад

Wow Thank you Mr. Chandoo ❤

@shivamaurya629 Год назад

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

@jenkinsade2111 Месяц назад

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

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

@tasmisa6778 Год назад

Dude you helped big time 👌✨🌙⭐

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

@rabin3333 Год назад

Thank you chandoo sir i like all your videos

@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

@yogeshbansal7184 Год назад

Thank you so much

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

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

@MuhammadIrfanShaikhOfficial Год назад

Very helpful

@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

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

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

@rajeshm7337 Год назад

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

@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

@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 RU-vid

@happyheart9431 Год назад

Million thanks

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

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

@owenvbugiejohnbull4826 Год назад

is this available in all versions or pro versions?

@severtone263 10 месяцев назад

Thank you

@ajithkumar-qw5rw Год назад

Love you brother ❤

@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 11 месяцев назад

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.

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

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

@insidehead Год назад

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

@michellebarnes7640 Год назад

Awesome! 😆

@satyaramavath6512 Год назад

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

@rohitsatpute3942 Год назад

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

@reemnasr1005 Год назад

Pls tell us about AI and data analysis

@harishmore7068 Год назад

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

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

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

@MisterWordExpert Год назад

In PowerPivot Dax will remove it or not?

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

@SSM_33 Год назад

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

@ashokuppalapati2688 Год назад

Super Anna

@honeydelhivlogger8047 Год назад

1 no. 😎🌟🌟

@vinodsoota1023 Год назад

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

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

@mangeshkamble556 Год назад

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

@yousrymaarouf2931 Год назад

Fantastic

@jeffbatista Год назад

Impressive

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

@SiraSam Год назад

I dont have this feature in preview

@AndrewJohnClive Год назад

Thank the Lord for that! ❤

@felipebarrera3060 Год назад

This has something to do with gpt from open ai?

@Navneey Год назад

What is the version of this power Bi

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

@user-ki6lu6od6n 9 месяцев назад

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

@SiraEkabutPlus Год назад

Wow!!

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

@manjotsingh4717 Год назад

Does this new feature uses chatgpt over here ?

@chinwee__o Год назад

The new feature still has some refining to go through.

@vinodgujja4268 Год назад

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

@chandoo_ Год назад

I am sure it is.

@pgkannan Год назад

Great news

@reyniekaewkham8719 Год назад

nice

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

@prudhvi5211 10 месяцев назад

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

@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_ 😂

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

@kartikeyshukla9181 Год назад

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

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

@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 10 месяцев назад

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

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

@picious Год назад

"Suggestions" is not available for all Regions !

@AntonioCarpioV Год назад

Lol that photo 😂😂😂

@hayatibrahim4615 Год назад

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

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

@inj1979 Год назад

Wow

@dariochavez5751 Год назад

wow

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

@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

@RK-wf7re Год назад

It's like ask data feature in Tableau.

@St8ofmind123456 Год назад

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

@keithmosaic3703 Год назад

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

@princemurali5509 Год назад

One of the great video

@yudapramana7040 Год назад

you always give valuable information, thanks

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

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