Power BI DAX Tutorial (18/50) - What is SWITCH Function

[@manishchavda1062]

Putting Content like this is real appreciable. It helped me a lot for practicing DAX. Looking for more Dax related videos to learn and growth. Thank you Nag

[@AnalyticswithNags]

Happy to hear that!

[@kruthikrishna3618]

why do we use sum('Product Master'['competitior Price']) instead of 'Product Master'['competitior Price']

[@ashokreddy3300]

Wt scenario u gave ,wt you have written,,, excellent work sir

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@RehanShaikh-ip9hh]

Hi, This is wonderful. just want small clarification. How did to bring competition price to your product master data ?? through related or any other formula. Pls explain...

[@AnalyticswithNags]

It is based on how your source system maintains data. In my case it is excel source I manually entered for demonstration

[@sandeepreddy7687]

Is true() is mandatory to write inside switch?

[@AnalyticswithNags]

It can be any valid expression Returns scalar value. Learn more about it here docs.microsoft.com/en-us/dax/switch-function-dax

[@ThePradeeppawar]

Hi Nag, Your Videos are super, could you please make the video about content pack and app, what is the difference between both of them also explain the workspace vs content pack vs app also usages

[@AnalyticswithNags]

Sure I will

[@raviranjansingh5527]

please make video on topn and rankx , it really confision for us , i hope you will make video on this topic Thanks sir ,making great explain with example .

[@AnalyticswithNags]

Okay sure

[@rakeshmahakud110]

Great 👍

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@ashisharora1462]

I am sry to say I didn't get why did you di this sum(competitor price) >0 why did you not compare it with sum(competitor price)> sum(cost price). how greater than 0 allows this

[@darshdaney]

It's like when the value in the competitor price column is more than 0 use that (competitor) value Otherwise (if you don't see a value) use cost price value. it's not like "if function" to compare sum(competitor price)> sum(cost price). it won't work here

[@AnalyticswithNags]

yes

[@anlithsimha9577]

Kindly please provide dataset.👍

[@AnalyticswithNags]

Data source file uploaded in description

[@thedeviceforgaming4419]

why did u have to use sum?