Use CONCATENATEX to Create Smart Visuals in Power BI
Vložit
- čas přidán 11. 06. 2024
- Practical Applications of CONCATENATEX Function in Power BI
In this video, we will learn how to use the CONCATENATEX function to create smart visuals in Power BI. You will also learn how to use this function to debug calculations, create advanced concatenated calculations, and enhance your reports. I’ll also guide you through a practical example, demonstrating how to use CONCATENATEX function in DAX to get the names of the top-selling products in a matrix visual.
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/learn-m-powerquery/
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step-by-Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/use-concatenatex...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers! - Věda a technologie
⬇Download the Power BI file - goodly.co.in/use-concatenatex-to-create-smart-visuals-power-bi
📊Mastering DAX & Data Modeling - goodly.co.in/learn-dax-powerbi/
You could also use that selected value measure to make a dynamic title for the visuals, add that little bit of something extra to the report.
Hi Mr. Chandeep, you are an excellent teacher. I learnt lots of Power Query tricks and DAX from your CZcams videos and still learning new tricks from every video you've made. I would like to join with your Power Query and DAX courses, however I would like to do a small request.
Is there any possibility to join with your course as a monthly subscription. If you would create in such a way it will be really helpful for person who is difficult to spend lots of money at once.
U are so crazy dammed awesome! Man!
Why can I only give 1👍? you deserve thousands of those.
Excellent way to explain the CONCATENATEX function and all its features and possibilities. I'm wondering if instead of creating a disconnected table, it would be easier to create a numeric range using a new parameter option. Additionally, another option to prevent the user from selecting more than one option in the "Top Value Selected" slicer is to set the slicer to "Single Select".
Cristal clear, as usual ! Thank u!
I am thinking about to decline this usage to build « topN and others »
Just by replacing « total N » calculation by « total - total N »
Looks like very elegant 🤩
Keep up the good work!
love the way you have explained it step by step, thank you.
👍Thanks, Chandeep!
No love 💔for the 'New Parameter' UI button for the dynamic slicer?
The effect would be identical, but you would also get the *non-range* 'slider' slicer which is (for some reason) exclusive to a parameter.
This is AWWWWESOMMMME👏🏿.
📌
Veramente fantastico.
Non ci sono parole per ringraziarti di questa condivisione.
Brilliant! That's really taking a basic function to the ultimate application
It's much more clear for a beginner also Thanks dear
nice one, short of words to describe the delivery process. 'nifty' may be 🙂
Just awesome❤
Very good
I can use this tomorrow. Thank you!
nice explanation👏👏👏👏👏👏
It’s really amazing
What a great short course
this is awesome
Brilliant 😮
wow the video just keeps getting better and better
Yep, this is what I looking for. Awesome as always, Chandeep
Very pedagogic format
Now why not a COALESCE hidden features video if any
amazing video as usual - should be able to harness some of this into my reports.
Brilliant content. Thank you
Brilliant as always!!!
Amazing
Excellent, thanks
Amazing 👍👍 Thanks for sharing
Awesome as usual!
Thank you. Really interesting thing. Also, instead of the calculation column, you can use the parameter (numeric range)
17:10 Wouldn't it be a better idea to set 'Single Select' on the slicer?
That is awesome ;-)
This is really a great trick, lets say we take it one more level to make Top N by dynamic ( By prod name, prod cat, prod subcat etc), how can we do that
Your Videos are fantastic.
Why in "Max Prod Sales" you use ALL{Products[Product Code]), why specify the column?
Its more efficient that way!
Can you write this function in power pivot same as you write
Can we use this function in PowerPivot?
Hi Sir Thank you so much for the video. One doubt,
In the quarter total line also showing the top products name. is that the best selling product of the entire year (because it is the total of all quarter)?
Yes, correct
خخخ فشيخ
Great follow up to your other intro's to the function, one gripe for me, I found UNICHAR does not work in P Pivot, UNICODE does, so you can find out that "A" = 65 , why one and not the other? ( Rhetorical)
The enter thing works in an excel PowerPivot too but you'll have to use use alt enter within quotes instead of UNICHAR(10)