Create insightful calculations using CONCATENATEX.

[@Henrik.Vestergaard]

What an incredible professional tutorial, amazing.

[@GoodlyChandeep]

Glad you like it Henrik!

[@JatinAhujajmd]

Amazing power of CONCATX function explained in easy steps! Kudos!

[@bradj229]

You always push the envelope with DAX, which is why I'm going to join your DAX training even after reading many books on DAX. Thanks!

[@IvanCortinas_ES]

This is a CONCATENATEX masterpiece. Thank you Chandeep!!!

[@GoodlyChandeep]

Glad you Liked it Iván!

[@mohammad.mujtaba]

That was brilliant brother, I wish you could learn from you. May You Be Blessed.

[@ugochukwunwasuruba1356]

This is beautiful Amazing insights on using Concatenatex. Thanks for sharing this.

[@ScottPerley]

I truly appreciate how clearly you describe this.

[@GoodlyChandeep]

Glad you appreciate Scott!

[@RaviNetwork]

Excellent! Simple example, clear explanation of syntax! Keep it up👏

[@vamshiabhilash]

OMG Chandeep the quality of explanation this function is top notch not even any online e-learning trainer would explain this crisp and clear🎉

[@GoodlyChandeep]

Glad It was helpful Vamshi!

[@sarveshdeshpande1772]

Simply brilliant and thanks for giving a use case along with that ….. 👍

[@GoodlyChandeep]

Glad you liked it Sarvesh!

[@ghulaamr2333]

Wow would be an understatement. Excellent and amazing, real life solutions. Keep it up.

[@pthapa55]

Great example, thanks. Loved your videos.

[@midhunmv3814]

Perfectly explained, thank you so much!

[@VikasSingh-bi4ot]

Just "WOW" 🔥in simplest way you have explain each single row. Chandeep, Thank you for giving us insightful videos, Keep going.... 😊👏👏👍

[@GoodlyChandeep]

Thank You Vikas!

[@guppi1]

Great tips, Chandep. I would like to know how you can sum all those concatenated value in the last part of the video

[@woliveiras]

Excellent explanation.

[@richardostrea7842]

Your presentation is getting better. Wow

[@GoodlyChandeep]

Glad you like this Richard!

[@AZ_German]

Nice step by step tutorial.

[@GoodlyChandeep]

Glad you liked it Alexander!

[@faisalag9611]

Awesome ,Thanks for sharing 🎉🎉

[@mnowako]

Awesome video! Thank you!

[@ramakumarguntamadugu1299]

Great content 👍👍🙏 looking forward for many such interesting videos

[@ramakumarguntamadugu1299]

If possible, could you please link the data files in the description box for easy downloading and practicing 🙏👍

[@charlesmtenga1670]

Very insightful,thanks.

[@jazzista1967]

Great example. How do you add a "catch all" calculation for the rest of the products that do are not the top 3? Thanks

[@GoodlyChandeep]

goodly.co.in/top-n-and-others-power-bi/

[@nitinsinghwal3973]

Hi It's really a nice example I can say amazing use.... however I found some issue, if let's suppose we do have same two product with same price and by co-incidence unit price sold is same in a particular month then top n function would give both product and sumx function would sum it up.

[@worldofdata]

amazing work chandeep :) thanks

[@zuhebkhan6973]

It will be great help for me and others sir make some video on it

[@mahathmasadineni2884]

Hi chandeep, Could you please do a video on how to get power queries refresh time duration and also how to pivot two columns in power query

[@OneNI83]

Nice one. Another approach to SQLBI ones.

[@decentmendreams]

Bro, you are PBI ninja. I see so many applications of this tip to my metrics. How to show negative values in red ? Thank you so much . Always easy for me to follow your train of thought.

[@decentmendreams]

or I could ask ChatGPT too.. this is what it gave me Best Prod = VAR TOTALREVE = [revenuety] VAR revenue = [revenuety] RETURN IF( revenue < 0, CONCATENATEX( TOPN( 3, FILTER( BobCombo, revenue ), revenue ), BoBCombo[SRP Name] & FORMAT(revenue, "| [$-en-US]$0.0;[Red]-[$-en-US]$0.0") & FORMAT(DIVIDE(revenue, TOTALREVE), " | 0%"), UNICHAR(10), revenue, DESC ), CONCATENATEX( TOPN( 3, FILTER( BobCombo, revenue ), revenue ), BoBCombo[SRP Name] & FORMAT(revenue, "| $0.0") & FORMAT(DIVIDE(revenue, TOTALREVE), " | 0%"), UNICHAR(10), revenue, DESC ) )

[@JJ_TheGreat]

8:04 But the amounts for each of the 3 products are all formatted are not all lined up with each other.

[@dfoster7001]

That is a great tutorial.

[@JJ_TheGreat]

5:55 Bingo... That's what I thought. As I said, I thought this kind of thing will and MORE confusion to your analysis, when being presented, than the benefit it would give. Again, you have 1 AMOUNT listed on your table - which corresponds to 1 PRODUCT - THE (1) TOP/BEST SELLING PRODUCT. But you have listed 3 products - and you could do a separate table showing this - the best selling amounts in 1 column and the product name in a 2nd column - and filter down to the top 3 in that table, if needed.

[@miguelbenito7992]

I will use it in Subtitle option. Thanks!!

[@GoodlyChandeep]

Brilliant idea

[@surajchavan6447]

Awesome !!😍😍👌👌

[@zuhebkhan6973]

I need one help on dax for range from and to numbers

[@Karandeep_singh81]

Hi Chandeep, you always create great videos with great info and it's very helpful for us to learn thru your channel. I recently came across a report where a Matrix view is there and on mouse hover, the complete row is highlighted instead of just that one cell. I tried to find the info on the web but had no luck, it would be nice if you know how it works, please create a video around the same or help with the steps on this post. Thanks in advance!!

[@GoodlyChandeep]

Can you share a link for me to see it?

[@amitsatnalika5760]

Hi Chandeep, thanks for the detailed vedio i have a small doubt here - since the product and calendar table are not related and there is one to many relationships exists between the product and sales table, so when we are creating a best sales product using the product table, the date filter context is not flowing into the product table .... so how this is determining the best-selling product for each specific month, in excel if we try the same, it will look for the whole of product table to give the best selling product ignoring the date filter.

[@GoodlyChandeep]

The best product is defined by TOPN and the month filter comes from the visual

[@amitsatnalika5760]

@@GoodlyChandeep i tried this in excel , this is not working the same way , i am getting topN across the product table irrespective of dates/month, happy to share the excel file

[@sonalijain8152]

Can we have distinct product names displayed

[@descubriendopowerbi7899]

Your channel is nice

[@tienngotk]

Great video bro.

[@GoodlyChandeep]

Glad you enjoyed Tienngotk

[@roderickmose4691]

Two thumbs up👍👍

[@GoodlyChandeep]

Glad you like it Roderick!

[@kurtdevotto]

Cool video, bro!

[@GoodlyChandeep]

Thanks Jean!

[@sunilpanikar1229]

How to start with power bi introduction? What are the recommended courses and link

[@GoodlyChandeep]

goodly.podia.com/power-bi-beginner-course

[@powerbinareal]

Sempre top!

[@unnikrishnansanthosh]

mastermind 💯

[@sandip_bettereveryday]

Awesome 😮

[@GoodlyChandeep]

Thank You Sandip!

[@santoshdevtale]

You are awesome Bro❤❤

[@GoodlyChandeep]

Thank You Santosh!

[@dutch-man]

Cool intro Chandeep 😁

[@GoodlyChandeep]

That's Mehedi's work!

[@dutch-man]

@@GoodlyChandeep props to Mehedi 😁

[@pbihari0214]

Thank you

[@NaraMeerammaTrust]

Can i download .pbix file for this topic? If so, Can you please let me know where can i go for downloads? Thak you

[@GoodlyChandeep]

goodly.co.in/concatenatex-enhance-dashboards-magically/

[@AshokSankarVarmaChekuri]

Good one bruh !

[@GoodlyChandeep]

Thanks Ashok!

[@JJ_TheGreat]

3:32 Wait .. But they only asked you, "What was the name of THAT product?"... Therefore, they are only asking specifically about the product of the amount of the "Best Prod Sales". So why do you need to give 3 products? I think that would be very confusing. If they wanted a list of the Top 3 selling products, they should have asked you - and then you could create a table specifically for that purpose.

[@juanignacioXI]

Nice one Chandeep, as an additional i dislike a lot the new upgrade 😢. New: Chandeep can u share the dax For that TOTAL in ur example please?

[@GoodlyChandeep]

I like it :)

[@arghyadutta9091]

Great

[@mogarrett3045]

awesome

[@GoodlyChandeep]

Thanks Mo!

[@vishnuderkar]

Nice Intro

[@GoodlyChandeep]

Thanks Vishnu!

[@zuhebkhan6973]

I have column from and to Eg: 123 in from column and 130 in To column Now my client need a column what is between number like 124,125,126,127,128,129 like so

[@sanjeevkhakre2990]

Hey chandeep I am interested in power bi course

[@GoodlyChandeep]

Great. How can I help?

[@sanjeevkhakre2990]

@@GoodlyChandeep Could you kindly tell me a little bit about your power bi and dax courses? I'd want to learn.

[@GoodlyChandeep]

@@sanjeevkhakre2990 Sanjeev, I'll request you to go through this link - goodly.co.in/learn-dax-powerbi And this link for Power Query - goodly.co.in/learn-power-query/

[@sergiod]

Maravillo

[@GoodlyChandeep]

Thanks Sergio!

[@user-bk8db7ud6k]

You think you are "good" at Power BI until you watch this guy, then you crawl back under your rock.

[@oscararmandocisnerosruvalc8503]

Agree hahahaha.

[@strangersingh6770]

Nice

[@GoodlyChandeep]

Thanks Stranger!

[@rogeriodornellas2115]

F**** . This is amazing!😃

[@zuhebkhan6973]

Hi Sandeep sir

[@jyotisantoshhiremath2855]

Hi, i have one scenario where i want only latest record in power query. Example: Column Names Emp ID, Emp Name, Visited Date. This is one hotel entry record. Record enter manually, record may be added in a month many times or some months may be not entered also. But i want only latest record entered date in table (power query). 1,Ajay,1/7/2021 2,Suraj,1/7/2021 3,Ram,1/7/2021 1,Ajay,1/9/2021 2,Suraj,1/9/2021 3,Ram,1/9/2021 1,Ajay,4/3/2022 4,Kamal,4/3/2022 1,Ajay,4/5/2022 4,Kamal,4/5/2022 1,Ajay,1/1/2023 2,Suraj,1/1/2023 3,Ram,1/1/2023 4,Kamal,1/1/2023 1,Ajay,1/3/2023 2,Suraj,1/3/2023 3,Ram,1/3/2023 4,Kamal,1/3/2023 for 2021 i need only 1/9/2021 for 2022 i need only 4/5/2022 for 2023 i need only 1/3/2023 record. if you need more information i will provide. Please make video on this it helps me lot

[@GoodlyChandeep]

This might help -- kzbin.info/www/bejne/oH3TmKdjrNWnfpY

[@jafarhussain6606]

hahaha, that's a bad handwriting. Amazing guy.