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