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 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
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.
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.
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!!
@@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/
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.
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.
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
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
What an incredible professional tutorial, amazing.
Glad you like it Henrik!
This is a CONCATENATEX masterpiece. Thank you Chandeep!!!
Glad you Liked it Iván!
Amazing power of CONCATX function explained in easy steps! Kudos!
This is beautiful
Amazing insights on using Concatenatex. Thanks for sharing this.
I truly appreciate how clearly you describe this.
Glad you appreciate Scott!
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!
Excellent! Simple example, clear explanation of syntax! Keep it up👏
That was brilliant brother, I wish you could learn from you. May You Be Blessed.
Simply brilliant and thanks for giving a use case along with that ….. 👍
Glad you liked it Sarvesh!
Excellent explanation.
Great example, thanks. Loved your videos.
Nice step by step tutorial.
Glad you liked it Alexander!
Perfectly explained, thank you so much!
OMG Chandeep the quality of explanation this function is top notch not even any online e-learning trainer would explain this crisp and clear🎉
Glad It was helpful Vamshi!
Awesome ,Thanks for sharing 🎉🎉
Wow would be an understatement. Excellent and amazing, real life solutions. Keep it up.
Two thumbs up👍👍
Glad you like it Roderick!
Awesome !!😍😍👌👌
Awesome video! Thank you!
Just "WOW" 🔥in simplest way you have explain each single row. Chandeep, Thank you for giving us insightful videos, Keep going.... 😊👏👏👍
Thank You Vikas!
Your presentation is getting better. Wow
Glad you like this Richard!
Great content 👍👍🙏 looking forward for many such interesting videos
If possible, could you please link the data files in the description box for easy downloading and practicing 🙏👍
Very insightful,thanks.
That is a great tutorial.
Awesome 😮
Thank You Sandip!
mastermind 💯
Thank you
Great example. How do you add a "catch all" calculation for the rest of the products that do are not the top 3? Thanks
goodly.co.in/top-n-and-others-power-bi/
amazing work chandeep :) thanks
Great tips, Chandep. I would like to know how you can sum all those concatenated value in the last part of the video
Your channel is nice
Great
You are awesome Bro❤❤
Thank You Santosh!
Great video bro.
Glad you enjoyed Tienngotk
I need one help on dax for range from and to numbers
awesome
Thanks Mo!
Sempre top!
Maravillo
Thanks Sergio!
Nice one. Another approach to SQLBI ones.
8:04 But the amounts for each of the 3 products are all formatted are not all lined up with each other.
Cool video, bro!
Thanks Jean!
It will be great help for me and others sir make some video on it
Can we have distinct product names displayed
How to start with power bi introduction? What are the recommended courses and link
goodly.podia.com/power-bi-beginner-course
Cool intro Chandeep 😁
That's Mehedi's work!
@@GoodlyChandeep props to Mehedi 😁
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.
The best product is defined by TOPN
and the month filter comes from the visual
@@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
I will use it in Subtitle option. Thanks!!
Brilliant idea
Nice
Thanks Stranger!
Nice Intro
Thanks Vishnu!
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
Good one bruh !
Thanks Ashok!
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.
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.
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
)
)
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!!
Can you share a link for me to see it?
Can i download .pbix file for this topic? If so, Can you please let me know where can i go for downloads? Thak you
goodly.co.in/concatenatex-enhance-dashboards-magically/
You think you are "good" at Power BI until you watch this guy, then you crawl back under your rock.
Agree hahahaha.
Hey chandeep I am interested in
power bi course
Great. How can I help?
@@GoodlyChandeep Could you kindly tell me a little bit about your power bi and dax courses? I'd want to learn.
@@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/
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?
I like it :)
F**** . This is amazing!😃
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.
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.
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
Hi Sandeep sir
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
This might help -- ruclips.net/video/jLpgt-wptH4/видео.html
hahaha, that's a bad handwriting. Amazing guy.