Power BI DAX Tutorial (22/50) - What is Summarize function in DAX | Group By in DAX

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

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

50% 1

What is summarize function in DAX
Create a calculated table in DAX, Create a virtual table in DAX and Apply aggregation on top of that., how to find Sum of Max values in DAX, Power bi dax tutorial with examples
#powerbi #powerbidax #summarize
🏬 Visit our Amazon Influencer Store 🏬 : www.amazon.in/shop/analyticsw...
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da...

Наука

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

26 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@hudzaifahhudzaifah-zv6yw 2 месяца назад

This helped me so much to understand SUMMARIZE. I stuck for 2 days why the filter context does not work with my table.

@AnalyticswithNags 2 месяца назад

Welcome

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

I am not able understand the summarize function bro can u explain it to me Summarize of table and we given the product name column so that it is going to display it in the new table right and we given a column for maxqts(measure) so it go display it also right .then why we are giving the max of sales quantity again when we have the maxqty (measure) already .

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

So that only it can give the total max as a grand total..??

@ebogart42 2 года назад

this helped a lot - thanks!

@AnalyticswithNags 2 года назад

Glad to hear it! Keep Learning

@pranavindi7152 3 года назад

great explanation. Thank you...

@AnalyticswithNags 3 года назад

You are welcome!

@sanjayanc1442 2 года назад

Hi. You might want to make another video on summarize fxn. The explanation is not as clear as other functions/videos. You are doing a great job btw.

@AnalyticswithNags 2 года назад

Thanks keep learning

@Yaks_TV 2 года назад

Hi, what if want to count those Product name with only MaxQnty = 3. . . I want to have it on Card Visualizations and reflect it. which in your example should result to 3 (Jeans Denim, Jeans Levis, and Jeans Zara, total of 3 in Card). What is DAX measure/formula? Thanks.

@AnalyticswithNags 2 года назад

Not sure what is your question

@ChandraShekar-dt2sh 2 года назад

Hi, Can u pls make video on to combine addcolumns & filter with Summarize...

@AnalyticswithNags 2 года назад

Not sure what was the relationship between this

@Lakshmi1010 3 года назад

Hi sir ..from where can I download all your datasets for my practice?

@AnalyticswithNags 3 года назад

Datasets will be a available in the description. Check for data source. If files doesn't not exist you can use previously video files.

@poojamaurya5715 2 года назад

Hello.. I have a table contains columns comments and differtn month,i want to group the comments month wise..i am using group by..but its only applicable for single month ,when i am using same Group by dax with other column name its Showing error. A table of multiple values was supplied,plz suggest wht should be done..

@AnalyticswithNags 2 года назад

Not sure about your question

@lawsonlutchman6921 2 года назад

Hi NAGS, wonderful video, I am trying to achieve the following summarized result, I have a measure that calculates the difference between 2 dates, another measure that categorizes the date differences as 1 Day, 2 Day and 3 Days and more. I need to count the occurrences of the day categories. I cannot create tables or columns as the source is a cube. I have tried.. 3DayCount = COUNTX(Summarize(FILTER('Leave Management','Leave Management'[DateDiff] = 3 ),"Leave 3 Day Category",'Leave Management'[DateDiff]),[DateDiff])

@AnalyticswithNags 2 года назад

Can’t help much on the query in comments.

@Bloody_August 2 года назад

Hi! Can we apply these solution to summarizecolumns? thanks!

@AnalyticswithNags 2 года назад

Yes. Try it

@UniversalFacts-unknown 2 года назад

Thanks sir. Can you please share a video on both summarize and addcolumns and differences b/w ..

@AnalyticswithNags 2 года назад

Soon will make a video

@banasaikrishna420 6 месяцев назад

Can we create the same summarize table in direct Query mode as well?

@AnalyticswithNags 3 месяца назад

Check playlists of this channel and explore topics on the similar line requested by you.

@umashankarverma3179 3 года назад

How to write condition like this in power bi 2> price< =5

@umashankarverma3179 3 года назад

Can u help me

@AnalyticswithNags 3 года назад

Sure. Here is the condition. Price > 2 && price

@rajeshkhanna8709 2 года назад

Hi I Have question that Min Or Max In table haveing highest Discount or lowest Discount Which supplier have min Discount I want ans like below Mohammed 1 I want ans Min Discount and Supplier name That into CARD Visual When we display same ans on card visual ans should be asc

@AnalyticswithNags 2 года назад

Didn't understand your question.

@rajeshkhanna8709 2 года назад

@@AnalyticswithNags In card visual Is that possible show Min Discount Amount With Supplier name

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

Supplier with Minimum Discount = VAR MinDiscount = [Minimum Discount] RETURN CONCATENATEX( FILTER('YourTable', 'YourTable'[Discount] = MinDiscount), 'YourTable'[SupplierName], ", " )