Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our RUclips channel 👉Please ping on WhatsApp wa.me/9916961234
Hi Bharath! Yes, you can concatenate both text and numeric values in DAX, but it's important to note that SUMX is primarily used for summing numeric values. If you want to concatenate the result of a SUMX calculation with text, you can do it like this: DAX Copy code TotalSalesWithText = "Total Sales: " & FORMAT(SUMX(Sales, Sales[Amount]), "#,##0") In this example, SUMX calculates the total sales, and then you concatenate it with the text "Total Sales: ". If you need more help or examples, feel free to ask!
@@KSRDatavizon I'm sorry, I don't see the source files anywhere in the Description of this video. Am I looking in a wrong description? Please help. Thank you.
Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our RUclips channel 👉Please ping on WhatsApp wa.me/9916961234
Again, this is a great video from KSR, thank you and keep up the good work. God bless.
Thanks, you too!
This is the best explanation
Thank You !
grx lesson watching from Nigeria
Thanks for watching, Thank you so much, please subscribe our channnel for regular updates and it motivates us a lot
It was very clear and clean. Thank you so much
You’re welcome 😊, Thank you, Please subscribe our channel for regular updates , all the best
Thank you so much
You're most welcome, You are welcome! Please subscribe our channel, it motivates us
Plz do more n more videos on real time projects which includes complex dax functions
sure
Your videos lot help for me thank you 😊
My pleasure 😊
Awesome explaintion
Thanks and Welcome
Explanation is great 😊 we can understand easily the sum and sumx in bi
Thanks and welcome
You are great sir
Thank you
Excellent explanation bro
Thank you so much Prakash.
Good one bro.
Keep do more....
Thank you, We will upload more. Keep watching
Please do the video all important dax expression video also
Hi Naresh, Thank you for reaching us, your check our channel for all DAX videos which was already uploaded.
Pls do an video real time project sir.
Hi, We will shortly upload the real time project video.- Thank You...!
Please do all DAX expressions sir . Also Upload kannada Tutorial also .
Sure we will upload soon
Sir can we concatenate both text and numeric value together in expression in sumx function
Hi Bharath! Yes, you can concatenate both text and numeric values in DAX, but it's important to note that SUMX is primarily used for summing numeric values. If you want to concatenate the result of a SUMX calculation with text, you can do it like this:
DAX
Copy code
TotalSalesWithText =
"Total Sales: " & FORMAT(SUMX(Sales, Sales[Amount]), "#,##0")
In this example, SUMX calculates the total sales, and then you concatenate it with the text "Total Sales: ". If you need more help or examples, feel free to ask!
Can you also explain pros and cons of Sum and Sumx as sumx calculates runtime does it takes much time to display the results??
sumx takes more time, as it is iterator function
Is there a place we can download the source files from please?
yes, its available in Description, please check and can use for your practice
@@KSRDatavizon I'm sorry, I don't see the source files anywhere in the Description of this video. Am I looking in a wrong description? Please help. Thank you.