⬇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/
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".
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 🤩
Hi Mr. Chandeep, you are an excellent teacher. I learnt lots of Power Query tricks and DAX from your UA-cam 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.
👍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.
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)?
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
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)
⬇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/
Excellent examples about the function and explains awsome,you are so great ,thanks for your share!
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".
17:10 Wouldn't it be a better idea to set 'Single Select' on the slicer?
amazing video as usual - should be able to harness some of this into my reports.
Brilliant! That's really taking a basic function to the ultimate application
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 🤩
love the way you have explained it step by step, thank you.
Piece of art there Chandeep!
It's much more clear for a beginner also Thanks dear
I can use this tomorrow. Thank you!
Veramente fantastico.
Non ci sono parole per ringraziarti di questa condivisione.
Yep, this is what I looking for. Awesome as always, Chandeep
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.
wow the video just keeps getting better and better
Hi Mr. Chandeep, you are an excellent teacher. I learnt lots of Power Query tricks and DAX from your UA-cam 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.
Amazing 👍👍 Thanks for sharing
Brilliant content. Thank you
Awesome as usual!
What a great short course
As usual Awesome!
👍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.
Keep up the good work!
nice one, short of words to describe the delivery process. 'nifty' may be 🙂
Brilliant as always!!!
AWESOME !!!!!
This is AWWWWESOMMMME👏🏿.
📌
Just awesome❤
Excellent, thanks
nice explanation👏👏👏👏👏👏
Thank you. Really interesting thing. Also, instead of the calculation column, you can use the parameter (numeric range)
It’s really amazing
Neat work can be shown to clients with conditional formatting which u have used in previous videos to highlight cell values as per requirement
Can you write this function in power pivot same as you write
Brilliant 😮
Can we use this function in PowerPivot?
this is awesome
Very good
Your Videos are fantastic.
Why in "Max Prod Sales" you use ALL{Products[Product Code]), why specify the column?
Its more efficient that way!
It is a magic. Thanks alot
That was amazing.
Very nice, could you also define the TopN value as a parameter rather than a disconnected table?
Unichar is not supported in Power Pivot, can you show me how to make new line in Concat?
That is awesome ;-)
That’s awesome!
Amazing
Very pedagogic format
Now why not a COALESCE hidden features video if any
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
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
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)
👌👍
خخخ فشيخ
Awesome