Perfect - I needed this! I don’t use PQ everyday, so I don’t always remember the basics but I’m getting there, thanks to tutorials like these! I am going to jump over to your website now to check it out! Thanks again for all your helpful content!
Thank you very much ,,, i'm following you since two weeks and i'm really too much appreciated your videos and its contents which always coming with a new informations we are really need to know about it such as power query ... so continue and we are supporting your videos... thank you
How about: IF column X > 10 then column X * - 1 ? So the result is a calc (col X * - 1) rather than just the contents of another column or a text string.
Hi Wyn, first of all thanks a lot for your videos! They are super helpful, I was considering using Power Pivot in order to do forecasting since having to use so much data and so many formulas in a single excel sheet is making super slow and difficult to work. I was wondering if it would be possible to do forecasting in power pivot considering that I need to calculate values with conditional formating linking cells with each other? My goal is at the end to only have the forecasted values from power pivot and not having all the formulas accross the whole excel sheet. Thank you!
Great video, thank you! Can you use wildcards in M? In large datasets like the blood group where it was O+ or O- if the data was manually entered would the query you created pick up an entry if it was just O or O++ because it was a typo? If you could use a wild card and had O* it could pick up anything.
this was great - but i have a question if i need to combine multiple conditions like what if blood type is either b+ or o+ and kg>60 & 50 - so how to frame the query .. i tried adding or and - but it isn't working correctly - may be a video on multiple coniditon and mltiple criteria might help
Hi Nelson, something like if ( [Type] = "b+" or [Type] = "O+" ) and [kg] > 60 then "Met" else "-" You may be missing on the the ( ) brackets to group the conditions
@@AccessAnalytic Hello - I was just thinking of doing a video explaining how to use the Advanced Editor when writing a more complex IF AND OR. Thinking about the M syntax, etc. Thanks!
Hi @@christophermajka623 , if I'm writing IF AND OR formulas that are more complex I still always use the Custom Column box as it gives you the ability to double click the columns you want to reference. I don't think there'd be any advantage in using the Advanced Editor for that scenario
Does this video and the link in its description help What is a Date Table / Calendar table in Power BI / Excel th-cam.com/video/LfKm3ATibpE/w-d-xo.html
@@AccessAnalytic i heard you say if with underscore !!!.. was not the case. after spending an hour found learnt the hard way that power query cannot display where the error is...till the mid half it said no syntax error where as the error was right in begining.... thk you bro. grt video though...
TH-cam and Wyn, along with other great contributors help me so much when I'm in a pickle. Thanks for keeping me out of the pickle brine!
Glad to help😀
IF AND OR - Simple but so useful. A good reminder that solutions don't need to be complicated. Thanks Wyn
Cheers Grainne
The way you explain things is amazing and precise.
Thank you so much for your endless efforts.
Very kind words Kamran, thank you
Wooow, It is simple but comprehensive explnation. Very helpfull content. Thank you.
Glad to help Priya
Perfect - I needed this! I don’t use PQ everyday, so I don’t always remember the basics but I’m getting there, thanks to tutorials like these! I am going to jump over to your website now to check it out! Thanks again for all your helpful content!
You’re welcome Irene. I find myself referring to my own videos and posts all the time 😀. Very hard to remember it all
Thank you very much ,,, i'm following you since two weeks and i'm really too much appreciated your videos and its contents which always coming with a new informations we are really need to know about it such as power query ... so continue and we are supporting your videos... thank you
That's great to hear. Thanks for taking the time to let me know Mohammed.
Clear, precise concise. There is no way to not subscribe after that.
Thanks Márcio
This was so doggone helpful!!! Thank you!!! It's exactly what I was looking for. 🙏🏽
Fantastic, thanks for letting me know it’s useful 😁
Hi Wyn. Thanks for the demo. Also, nice to know about your dummy data.. very helpful when practicing concepts. Thanks for sharing :)) Thumbs up!!
Glad to share and hope it comes in useful
Thanks Wyn.....just tried.....very useful. Kr, Luca
Great!
Great share!
I often forget to add a proper name to a new table, so like you, I added Change Table Name to QAT, under All Commands.
Good one
From two weeks I was stuck on finding if 2 dates and time fall between 2 dates and time. and after watching this I have a solution. Thank you
Excellent Urooj, thanks for letting me know!
thank you this is such a life saver
No worries. Thanks for letting me know
Of course thumbs up!! Thank you Wyn!
No worries Iván
Thank You. That was really helpful.
You're welcome
Hi Wyn, is it possible for the result of the IF statement in M to be a numerical calculation? Or does it always have to be a text value?
Hi, sure is e.g. IF ColumnX < 10 then Y etc
How about: IF column X > 10 then column X * - 1 ? So the result is a calc (col X * - 1) rather than just the contents of another column or a text string.
@@Metzanine , yep but you have to hand write it via Add Column - Custom Column rather than using the Conditional Column wizard
Hi Wyn, first of all thanks a lot for your videos! They are super helpful, I was considering using Power Pivot in order to do forecasting since having to use so much data and so many formulas in a single excel sheet is making super slow and difficult to work. I was wondering if it would be possible to do forecasting in power pivot considering that I need to calculate values with conditional formating linking cells with each other? My goal is at the end to only have the forecasted values from power pivot and not having all the formulas accross the whole excel sheet.
Thank you!
Hopefully you got my note
Great video, thank you! Can you use wildcards in M? In large datasets like the blood group where it was O+ or O- if the data was manually entered would the query you created pick up an entry if it was just O or O++ because it was a typo? If you could use a wild card and had O* it could pick up anything.
Cheers, you might need Text.Contains powerquery.how/text-contains/
thank you for the video, and yes it was helpful!
Great, thanks for letting me know
Great explanation and also thank you for the fake data set links
No worries 😀
Thanks for sharing! 👍
You’re welcome
this was great - but i have a question if i need to combine multiple conditions like what if blood type is either b+ or o+ and kg>60 & 50 - so how to frame the query .. i tried adding or and - but it isn't working correctly - may be a video on multiple coniditon and mltiple criteria might help
Hi Nelson, something like if ( [Type] = "b+" or [Type] = "O+" ) and [kg] > 60 then "Met" else "-" You may be missing on the the ( ) brackets to group the conditions
Yes, I was indeed missing the brackets. Thanks for the reply.
You’re welcome
How to write if or formula in a power query if there are more than 2 conditions? Thank you.
You might find my new video useful th-cam.com/video/o9qAov3kSN4/w-d-xo.html
Great video Wynn! Can we also do one using the query editor :)
Thanks Christopher. Are you asking if I can do a video explaining the Advanced Editor?
@@AccessAnalytic Hello - I was just thinking of doing a video explaining how to use the Advanced Editor when writing a more complex IF AND OR. Thinking about the M syntax, etc. Thanks!
Hi @@christophermajka623 , if I'm writing IF AND OR formulas that are more complex I still always use the Custom Column box as it gives you the ability to double click the columns you want to reference. I don't think there'd be any advantage in using the Advanced Editor for that scenario
Can we use countif function like excel??
Sort of, using GROUP BY and countrows but normally it's better to do that in Power BI or Power Pivot after loading the data from Power Query
Thanks 👍
No worries
thank you!
No worries
Great. Thanks...
Hope it helps a few people starting out
Hi, thanks You solutions, i need much relation about tablet for date, please
Does this video and the link in its description help What is a Date Table / Calendar table in Power BI / Excel
th-cam.com/video/LfKm3ATibpE/w-d-xo.html
in custom column after typing then.. it shows error!! why!! dnt get it
What error does it show
@@AccessAnalytic i heard you say if with underscore !!!.. was not the case. after spending an hour found learnt the hard way that power query cannot display where the error is...till the mid half it said no syntax error where as the error was right in begining.... thk you bro. grt video though...
Can you do If isblank??
Yep, if [column name] = null