You are truly a gem, shining brightly with your kindness, wisdom, and warmth. Your presence brightens the lives of those around you, and your actions inspire others to be their best selves.❤
You formula is hard-coded. It will not work if there are a few more rows like LMN, OPQ, RST. Imagine there are 100 rows, then you need to write 101 nested IF dax functions.
As amazing content as you are 🌹 Request you to Create a Video on Publishing the Reports to Dev 2 Testing and then to Production as it's being asked in many interviews!! Thank you once again for a wonderful support ☺️
instead of Switch I just put the function "Category = IF(CONTAINSSTRING(Bike[Product],"Bike"),"Bike","Accessories")" & got the result. Hope this is also true
Hi Shashank ,Thanks for all of your videos and efforts ,Much appreciated its helped me a lot in interview preparations. Below are 2 DAX scenario which is asked in Birla Soft Interview. Please make videos on that . Que 1 : Column A Category ABCBike Bike EFGHJ Accessories DEFBike Where ever Bike is there it should return value as "Bike" else "Accessories". Que 2: Column A Column B A 80 B 60 C 30 D 50 How to find out how much percentage each column is contributing using DAX? Que 3: Write a DAX query to see 7 days ago sales. Your replay will be much appreciated.
In techm , in managerial round, interviewer asked to me that how to refresh a dashboard /report( exactly not remember) in every 5 min ? Can someone tell me the ans
It can only be done when we connect to data via direct query mode. Import mode has a restriction of 30 minutes between each refresh. Direct query mode removes all restrictions and can load live up-to-date data.
Yes, when you publish your report, i.e on web which means Power BI service, you get options on the left panel. In which, you'll have an option of Schedule Refresh. You can refresh the data either Daily/Weekly. And additionally there are options beneath like you can set time for refresh, but you can do this only 8 times a day. I'm not sure if it's free, I guess it's achievable in Power BI Pro Licence. Correct me if I am not wrong, @LearnWidGiggs bhaiya ✨
Learn all basic functions text, logical, date and time, filter, maths and statistics and time intelligence. They will get you through most of the challenges. Remaining functions are on case to case basis, it's impossible to know all Dax functions.
Hello shashank sir, i got 2 job offer as fresher, 1st in US IT staffing firm as web analyst in digital marketing dep. i think and 2nd in Service providing startup as Python developer with django. so i want to move in data engineering or data analyst career path in future. which profile should be best. web analyst same as data analyst or different, thank you
Thought of using switch and containstring But could not figure out how to use the containstring and switch function :( So did the below:- var a = SEARCH("bike",'Product'[Product Name],1,BLANK()) RETURN IF(a=BLANK(),"Accessories","Bike") Bdw, just completed the powerbi from codebasics 2 days back. But still need to practice a lot to write DAX formulas and figure out how to work on project.
I used this way to achieve the result.
Category = IF(CONTAINSSTRING('EY'[Product],"bike"),"bike","Acc")
Great.
You are truly a gem, shining brightly with your kindness, wisdom, and warmth. Your presence brightens the lives of those around you, and your actions inspire others to be their best selves.❤
You are so welcome
Var t= search(" book", column name,1,0) var t1 = if (t>0,"book","accessories") return t1
We can also used IF() Function, here.!
Switch function takes more condition than IF().
We can use “IF” Condition also for this .
If(EY[Product] = “DEF” ,”Accessories”,
If(EY[Product] = “LFG” ,”Accessories”,”Bike”))
seems this is only a manual solution, for e.g XYZ data is present in the product name column that time we need to use the same dax used in the video
You formula is hard-coded. It will not work if there are a few more rows like LMN, OPQ, RST. Imagine there are 100 rows, then you need to write 101 nested IF dax functions.
We can use IF - similarly as Switch with Containsstring.
IF(CONTAINSSTRING(EY[Product Name]) = "Bike", "Bike", "Accessories")
As amazing content as you are 🌹
Request you to Create a Video on Publishing the Reports to Dev 2 Testing and then to Production as it's being asked in many interviews!! Thank you once again for a wonderful support ☺️
+1
instead of Switch I just put the function "Category = IF(CONTAINSSTRING(Bike[Product],"Bike"),"Bike","Accessories")" & got the result.
Hope this is also true
Great
We can also make use of if function I did in this way.
Ctaegory = IF(CONTAINSSTRING(EY[Product name],"bike"),"Bike","Accessories")
Solution -
Col2 =
IF((SEARCH("Car",'Sample'[Col1],,0)),"Bike","Category")
Same type of question was asked in citiustech
Hi Shashank ,Thanks for all of your videos and efforts ,Much appreciated its helped me a lot in interview preparations.
Below are 2 DAX scenario which is asked in Birla Soft Interview.
Please make videos on that .
Que 1 :
Column A Category
ABCBike Bike
EFGHJ Accessories
DEFBike
Where ever Bike is there it should return value as "Bike" else "Accessories".
Que 2:
Column A Column B
A 80
B 60
C 30
D 50
How to find out how much percentage each column is contributing using DAX?
Que 3: Write a DAX query to see 7 days ago sales.
Your replay will be much appreciated.
Can you give some clarity for the 2nd question?
And for 3rd question is it last 7 days sales or Last 7th day sale he wants?
Thank you Shasank for posting this in your channel. I will share more questions which I faced in EY.
Thank You Bhai
welcome, plz do share.
Bahut badhiya video @shashank bhai
Thank you 🙏
Could you please create a video on how to create a multi lingual report in power bi? If any one knows please give your inputs.
Thanks
do more content in DAX same like this
Thank you for sharing this valuable information with us
Welcome
Is there any way to get current page name as measure? My intention for this is I need to pass dynamic parameter to calendar function as start date
Hi sir, which one is best clurse for data analyst , Is it the course provided by code basics or growdata skills. Please suggest
I believe Codebasics will be a good choice.
@@learnwidgiggs thanks will purchase that course
Sir true function nhi smjha q liye switch me
Hi sir can u plz make video for 3+ powerbi developer resume.
Itna easy question if and search function se hi ho jaayega ..
You are very helpful person!🙏
Glad you think so🙏
Fantastic one Bhai Kudos 😊🎉
Thanks for liking.
thank you so much for sharing the relatd content
Welcome
Thank you sir for this informative video
Most welcome
In techm , in managerial round, interviewer asked to me that how to refresh a dashboard /report( exactly not remember) in every 5 min ? Can someone tell me the ans
It can only be done when we connect to data via direct query mode. Import mode has a restriction of 30 minutes between each refresh. Direct query mode removes all restrictions and can load live up-to-date data.
Yes, when you publish your report, i.e on web which means Power BI service, you get options on the left panel. In which, you'll have an option of Schedule Refresh. You can refresh the data either Daily/Weekly. And additionally there are options beneath like you can set time for refresh, but you can do this only 8 times a day. I'm not sure if it's free, I guess it's achievable in Power BI Pro Licence. Correct me if I am not wrong, @LearnWidGiggs bhaiya ✨
@@akashhanchatet-2842 yes we can refresh 8 times for powerbi pro license and we can refresh 48 times for premium license its based on license
Really informative video sir🙏
Glad you liked it.
Bhaiya ....there are n number of DAX codes are there .How to know which dax fucntion to use and when to use ? Is there any tricks to know ?
Learn all basic functions text, logical, date and time, filter, maths and statistics and time intelligence. They will get you through most of the challenges. Remaining functions are on case to case basis, it's impossible to know all Dax functions.
Yes learn all basic text, logical, date and time, filter, mathematical & statistics and time intelligence functions.
Hello shashank sir, i got 2 job offer as fresher, 1st in US IT staffing firm as web analyst in digital marketing dep. i think and 2nd in Service providing startup as Python developer with django. so i want to move in data engineering or data analyst career path in future. which profile should be best. web analyst same as data analyst or different, thank you
You will have to check the job description and then only decide.
Python developer with django is not a Data Analyst position
8200 ka. Ho gyw h wha ab price
Thought of using switch and containstring
But could not figure out how to use the containstring and switch function :(
So did the below:-
var a = SEARCH("bike",'Product'[Product Name],1,BLANK())
RETURN
IF(a=BLANK(),"Accessories","Bike")
Bdw, just completed the powerbi from codebasics 2 days back.
But still need to practice a lot to write DAX formulas and figure out how to work on project.
Great, keep learning.
informative
can i use if statement in this ??
Yes.
Any immediate joiners for power bi role, ping me I will provide referral.
Hi
Hi
Hi Mahendra
I will join immediately, plz refer me
Hi