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, 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 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!!
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
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.
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
@@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/
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.
What an incredible professional tutorial, amazing.
Glad you like it Henrik!
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!
This is a CONCATENATEX masterpiece. Thank you Chandeep!!!
Glad you Liked it Iván!
This is beautiful
Amazing insights on using Concatenatex. Thanks for sharing this.
That was brilliant brother, I wish you could learn from you. May You Be Blessed.
I truly appreciate how clearly you describe this.
Glad you appreciate Scott!
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!
Excellent! Simple example, clear explanation of syntax! Keep it up👏
Perfectly explained, thank you so much!
Great example, thanks. Loved your videos.
Simply brilliant and thanks for giving a use case along with that ….. 👍
Glad you liked it Sarvesh!
Just "WOW" 🔥in simplest way you have explain each single row. Chandeep, Thank you for giving us insightful videos, Keep going.... 😊👏👏👍
Thank You Vikas!
Great tips, Chandep. I would like to know how you can sum all those concatenated value in the last part of the video
Your presentation is getting better. Wow
Glad you like this Richard!
Excellent explanation.
Wow would be an understatement. Excellent and amazing, real life solutions. Keep it up.
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
Awesome ,Thanks for sharing 🎉🎉
Awesome video! Thank you!
Very insightful,thanks.
Nice step by step tutorial.
Glad you liked it Alexander!
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/
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 🙏👍
It will be great help for me and others sir make some video on it
I need one help on dax for range from and to numbers
I will use it in Subtitle option. Thanks!!
Brilliant idea
Can we have distinct product names displayed
Nice one. Another approach to SQLBI ones.
amazing work chandeep :) thanks
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, 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
Thank you
How to start with power bi introduction? What are the recommended courses and link
goodly.podia.com/power-bi-beginner-course
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?
That is a great tutorial.
8:04 But the amounts for each of the 3 products are all formatted are not all lined up with each other.
Awesome !!😍😍👌👌
Your channel is nice
mastermind 💯
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
Two thumbs up👍👍
Glad you like it Roderick!
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/
Cool video, bro!
Thanks Jean!
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 :)
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.
Great video bro.
Glad you enjoyed Tienngotk
You are awesome Bro❤❤
Thank You Santosh!
Cool intro Chandeep 😁
That's Mehedi's work!
@@GoodlyChandeep props to Mehedi 😁
Awesome 😮
Thank You Sandip!
Great
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
Good one bruh !
Thanks Ashok!
awesome
Thanks Mo!
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 Intro
Thanks Vishnu!
Maravillo
Thanks Sergio!
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.
You think you are "good" at Power BI until you watch this guy, then you crawl back under your rock.
Agree hahahaha.
Hi Sandeep sir
Nice
Thanks Stranger!
F**** . This is amazing!😃
hahaha, that's a bad handwriting. Amazing guy.
Sempre top!