Sir, You have a quality to clear the things crystal clear. I really enjoying your videos there many Gurus but you are always adopting not only simple method but also shows us other side of coin as well. Thanks Take Care
You have a gift for explanation coupled with planning of pertinent examples. There is no reason to listen to other channels for learning dax as they just don't compare. If I continue my dax career, will be purchasing your course.
Thank you so much for this video. It was more helpful then most of the others I watched!! I understand much better than before how and why to use a measure.
Thanx for the video...The sumx doesn't work with the values of type string. How to work with the string values? i want the output to be in string type such as Yes or No.
I was using "and" on a single column by creating a calculated table but I got blank table. Calculatedtable ( Summarize(Orders, orders[shipmode], "Total Sales", Sum(orders[Sales])), Orders[shipmode] = "First Class" && Orders[shipmode] = "Second Class") But when I used OR instead of AND its give me the required records as mention in the expression. It's little bit confusing to find why its not taking the values from single column by using AND condition. Is AND condition works on multiple column or anything else is happen in this dax
This is so great , i did not know this, you opened te new level for me, many thanks. i also want to share one problem i am facing while using nested IF DAX in buckets, it is not giving me appropriate results. can you please advise or HELP...
I want to apply the if(and()) function on the other table and I want to return the value on the other table. Please let me know that how can I do this operation?
Do you exclusively use && or || when using multiple IF/OR functions in DAX, even when there are only two variables? I'm not sure if I should start using this format exclusively when using multiple IF/OR functions so my functions always have the same format regardless of number of variables.
the content i need at the speed i need... simply awesome!
You have saved me what I have been trying to fix for weeks now, thanks a bunch man
This was helpful. Right to the point without wasting time. It was a very good video.
Glad it helped!
Sir, You have a quality to clear the things crystal clear. I really enjoying your videos there many Gurus but you are always adopting not only simple method but also shows us other side of coin as well.
Thanks
Take Care
You have a gift for explanation coupled with planning of pertinent examples. There is no reason to listen to other channels for learning dax as they just don't compare. If I continue my dax career, will be purchasing your course.
clear concise explanation with solutuion of one of the initial dax challenges faced by beginners recommend this tutorial
That was a lot of information packed in seven minutes. Well done!
Glad you enjoyed it!
Thank you so much for this video. It was more helpful then most of the others I watched!! I understand much better than before how and why to use a measure.
Glad it helped!
So far the best explanation on logical Dax. If You could provide a detailed explanation on Summarize that would be great.
Quick, precise explanation w many examples and contrasts. Good teaching
Glad I could help!
Amazing! Thank you a lot! Informative and great speed. Exactly what I needed.
Glad it helped!
TEMPO is great, that kind of tutorial what i was looking for. Thanx!
Thanks Man.. Glad you found it helpful
What would be the dax equivalent to Indirect function in excel? I am trying to get the max row wise of two categories. Please help
Well explained. The way you are explaining, amazing.
Glad you like it 💚
Very well explained 🔥 'IF' function 🔥
Glad you liked it
This was just exactly what I needed. Thanks a bunch
What is the command/syntax to type if you want to numerical or text result that is already in a column?
Thanx for the video...The sumx doesn't work with the values of type string. How to work with the string values? i want the output to be in string type such as Yes or No.
This was so helpful and very well explained. Thank you!
I was using "and" on a single column by creating a calculated table but I got blank table.
Calculatedtable (
Summarize(Orders, orders[shipmode], "Total Sales",
Sum(orders[Sales])),
Orders[shipmode] = "First Class" && Orders[shipmode] = "Second Class")
But when I used OR instead of AND its give me the required records as mention in the expression. It's little bit confusing to find why its not taking the values from single column by using AND condition.
Is AND condition works on multiple column or anything else is happen in this dax
Hi. How do u get the correct grand total with measures created.
can't we use selectedvalue( ) in if statement to get sales channel?
Thanks a lot Man, you just saved me a lot. Much appreciate this Video. :)
This is so great , i did not know this, you opened te new level for me, many thanks. i also want to share one problem i am facing while using nested IF DAX in buckets, it is not giving me appropriate results. can you please advise or HELP...
How do we differentiate orders which have been shipped from multiple sites? Mean, if order is shipped from multiple site then yes else no
Very nice explanation.
Glad you liked it
I want to apply the if(and()) function on the other table and I want to return the value on the other table. Please let me know that how can I do this operation?
Do you exclusively use && or || when using multiple IF/OR functions in DAX, even when there are only two variables? I'm not sure if I should start using this format exclusively when using multiple IF/OR functions so my functions always have the same format regardless of number of variables.
The inbuilt AND OR function just allow for 2 conditions. No more.
So I use && and || everywhere I need to test for conditions
Why didn't you need SUMX when doing the second if measure statement?
Thanks, another terrific video!
Thanks again!
Very nice chandeep ♥️♥️ please post more video on DAX functions🙂🙂
Sure I will :)
Thank you! Thank you! Thank you!
Very didactic. Just for clarification, could you show the measure [Total Sales] used within the "IF" measure?
That'll be straight forward
IF ( [Total Sales] BLANK(), True Action, False Action )
Thanks, well explained!
You're a saviour
Great explanation
well done mate. Good job
Thanks I got my solution
Thank you so much, 🙌🙌🙌
You're welcome 😊
Its a first time i can't understood well😮
Excellent
Glad you found it helpful
Awesome
nice, thank you
You're Welcome 😊
Can you pls go a bit slow??
great, i tried to do if function for a long time. Where can I learn more about it?