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!!
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 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
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
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.
@@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/
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!
Excellent! Simple example, clear explanation of syntax! Keep it up👏
This is a CONCATENATEX masterpiece. Thank you Chandeep!!!
Glad you Liked it Iván!
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!
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!
Wow would be an understatement. Excellent and amazing, real life solutions. Keep it up.
Perfectly explained, thank you so much!
Great example, thanks. Loved your videos.
Nice one. Another approach to SQLBI ones.
Awesome !!😍😍👌👌
Great tips, Chandep. I would like to know how you can sum all those concatenated value in the last part of the video
Awesome video! Thank you!
That is a great tutorial.
Your presentation is getting better. Wow
Glad you like this Richard!
Awesome ,Thanks for sharing 🎉🎉
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.
Two thumbs up👍👍
Glad you like it Roderick!
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
)
)
amazing work chandeep :) thanks
Your channel is nice
Nice step by step tutorial.
Glad you liked it Alexander!
Sempre top!
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
Great
It will be great help for me and others sir make some video on it
Great video bro.
Glad you enjoyed Tienngotk
I will use it in Subtitle option. Thanks!!
Brilliant idea
Thank you
awesome
Thanks Mo!
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?
Cool intro Chandeep 😁
That's Mehedi's work!
@@GoodlyChandeep props to Mehedi 😁
Nice Intro
Thanks Vishnu!
Awesome 😮
Thank You Sandip!
Cool video, bro!
Thanks Jean!
You are awesome Bro❤❤
Thank You Santosh!
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 :)
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/
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 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 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
Maravillo
Thanks Sergio!
Good one bruh !
Thanks Ashok!
Hi Sandeep sir
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
You think you are "good" at Power BI until you watch this guy, then you crawl back under your rock.
Agree hahahaha.
8:04 But the amounts for each of the 3 products are all formatted are not all lined up with each other.
I need one help on dax for range from and to numbers
F**** . This is amazing!😃
Nice
Thanks Stranger!
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 -- ua-cam.com/video/jLpgt-wptH4/v-deo.html
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.
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/
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/
hahaha, that's a bad handwriting. Amazing guy.