Thank you for the video and I have a question please. What is the equivalent of the following in power query language: =IF(a2="name", if(b2=3, if(c2>1,"true","false),"false"),"false") Please I would really appreciate it!!
Thanks for this. Can you please explain why I get the following error: '= if Text.Contains([Month], "November") then "Nov / Dec" or Text.Contains([Month], "December") then "Nov / Dec")' The second 'Nov' (i.e. there is a red scribbly line under it) gives an error which doesn't make sense at all as it is the value I determine it to be.
Dear Sir, i have a spreadsheet where I have names in two different columns - the columns include data other than names due to export to excel. I want to add a conditional column to include the names only (without filtering in which case I lose necessary data). I tried using If Column Contains Mr but Output does not give an option to bring the entire cell value to have the full name . Would you please advise?
Commission .5 :) .. should have been .05. Thanks for the great videos!
Good one. you have to use very simple examples to show complicated ones.
.1 and .05
But Your efforts are really appreciate we are too much learn from u....
Thanks sir...🙏🙏🙏
Thank you Sumit it was super helpful.
Another great video. Thanks for sharing. 🙌🙌🙌
Great video, really useful and clearly explained. Thank you 😊.
Thanks for useful Video. Could you please advise how can we do multiple if conditions in this scenario?
great video!!!
Excellent work!
Thank you!!
Thanks a lot.
Thank you so much!!!!!!!!!!!!!!!!!!!!!!!!!!
Great thanks!
Great . Sumeetji, You are a genius. Can we make a formula with if, and ,and or all in one.
How can we use both OR and AND together in one formula?
Or all three operators AND, OR and NOT
Thanks my friend.
A good video
Can you advise what will be the syntax in Power Query for the following
=if(or(B2="Apple", B2="Orange"), B4, 0)
thanks
Thank you for the video and I have a question please.
What is the equivalent of the following in power query language:
=IF(a2="name", if(b2=3, if(c2>1,"true","false),"false"),"false")
Please I would really appreciate it!!
hi friend, how can i replace a cell with a null value with the value from another column? i.e replace null in A3 with name from C3
Thanks for this. Can you please explain why I get the following error: '= if Text.Contains([Month], "November") then "Nov / Dec" or Text.Contains([Month], "December") then "Nov / Dec")'
The second 'Nov' (i.e. there is a red scribbly line under it) gives an error which doesn't make sense at all as it is the value I determine it to be.
Dear Sir, i have a spreadsheet where I have names in two different columns - the columns include data other than names due to export to excel. I want to add a conditional column to include the names only (without filtering in which case I lose necessary data). I tried using If Column Contains Mr but Output does not give an option to bring the entire cell value to have the full name . Would you please advise?
I am a teacher and l will need your help for some calculation. Would you help me?
May I help you? Plz share your query. May b I could help u.