Great publishing sir ji, and thank you so much for considering our request, kepp making the advanced functions videoes like this because such a joy to watch you teaching and providing so much knowledge you have. Great 👍👍👍👍
Dear Sir, You have published again another excellent video on power bi dax formulas. Kindly make more power bi beginner to advance level dax formulas in near future. One more request to you sir kindly make videos on offset function in excel. Thanks & Regards Jayanta Bhattacharyya
If anyone wants to find the Last Name , you can use this logic to take out the substring while ' ONLY ' using DAX formula:- 🔽🔽🔽🔽 //Make a new column search underscore = SEARCH("_",[Email address],,LEN([Email address])) //Make another new column search attherate = SEARCH("@",[Email address],,LEN([Email address])) //Finally make Last Name column Last Name = MID([Email address],[search underscore]+1,[search attherate]-[search underscore]-1) 😄Happy Learning !
Very nice video.. excellent. Sir- When I going to use same formula( First Name = LEFT([Email],FIND("@",[Email])-1) ) in Power Bi ( Model), Then we getting error " The search Text provided to function 'FIND' could not be found in the given text." Please guide me in finding best way possible.
Hi Ashish ji..aap office 2016 kiyo intall karna chate hai..ab to office 2019 and office 365 ka time hai...aap office 2019 ko intall kariye aapko bahut videos mil jaegi RUclips mein ..how to install office 2019..
Very nice video.. excellent 👍... Please provide more DAX videos.. beginning to Advance level.
Thank you so much sure will try to make more videos..dont forget to share this video
@@GyanOnTube me and my 3 friends always watch your power Bi videos.. I share to them👍
Thanks once again
@@jameerahmad9169 so nice of you ..thank you so much for your support
interesting video
Thank you so much
it was very informative and useful.
Thank you so much
Great publishing sir ji, and thank you so much for considering our request, kepp making the advanced functions videoes like this because such a joy to watch you teaching and providing so much knowledge you have. Great 👍👍👍👍
Thank you so much Pankul ji for your valuable comment..thank you
Thanks for the excellent tutorial.
Thank you so much
Dear Sir,
You have published again another excellent video on power bi dax formulas. Kindly make more power bi beginner to advance level dax formulas in near future. One more request to you sir kindly make videos on offset function in excel.
Thanks & Regards
Jayanta Bhattacharyya
Thank you so much for your valuable comment...sure in future i will make more dax videos..
Thank you so much sir 🙏❤
@@26sushmitagawade93 thank you so much
Im just starting to learn Power BI should I consider him to learn from scratch or not??Have u learned from him or not
Thank you so much sir..... Very easy way.
Thank you 😊
Excellent video
Thank you so much
Great teaching
Thank you so much..fo not forget to share this video for better reach
Great sir ji
Thank you so much
Nice video
Thanks
If anyone wants to find the Last Name , you can use this logic to take out the substring while ' ONLY ' using DAX formula:-
🔽🔽🔽🔽
//Make a new column
search underscore = SEARCH("_",[Email address],,LEN([Email address]))
//Make another new column
search attherate = SEARCH("@",[Email address],,LEN([Email address]))
//Finally make Last Name column
Last Name = MID([Email address],[search underscore]+1,[search attherate]-[search underscore]-1)
😄Happy Learning !
Happy learning
This power bi videos is enough for data analysis?
Yes its enough
Nice one Sir, will it continue to work if we append the next set of data below this, I hope yes.
Good
good
Thank you
I am very greatful that i found your video , Can you please make video on how to get job in powerbi pleaseeee its an humble request
Sure will do
why dont we split column through the delimeter
Jaise excel mai formula use krte h waise he sare formula power bi mai use hoge
Ho sakta hai but bahut bari same formula hamare power bi mein available nhi hota to humko trick lagani parti hai..
sir, while entering new column it always shows error and can we add a column without formula and error
We can add new column only with formula
@@GyanOnTube it isn't working, it gets hide and everytime it show error, please guide how to solve this
Hello sir, when we separate emailadress into first and last column we put the -1 in formula plz explain in detail
Just to remove underscore...
@@GyanOnTube Thanks for reply but sir there is no any underscore in emailadress column so plz..explain
Then remove @
@@GyanOnTube Thanks a lot🙏.so we can say that to remove @,underscore, etc. We always use -1 in formula
Yes
super
Thank you so much
hello sir , thank you for all formula......is it possible if you can add the sumifs formula for power bi
Yes use calculate and filter function
Brother table me cell merge krne ka koi tarika mila kya ???
Nhi Ghuman ji ..mene search kiya tha but kuch nhi mila..
Very nice video.. excellent. Sir- When I going to use same formula( First Name = LEFT([Email],FIND("@",[Email])-1) ) in Power Bi ( Model), Then we getting error " The search Text provided to function 'FIND' could not be found in the given text." Please guide me in finding best way possible.
We can break the function and then try
@@GyanOnTube ok sir thank you 😊 🙏
Sir , ms office 2016 ko free download and install करने का तरीका बताए
Hi Ashish ji..aap office 2016 kiyo intall karna chate hai..ab to office 2019 and office 365 ka time hai...aap office 2019 ko intall kariye aapko bahut videos mil jaegi RUclips mein ..how to install office 2019..
Dear Sir,
I want to contact you . Your insta id not working.
Please check tha is the same