Power Query IF AND OR.

[@-Hussainnn]

Great Flash fill used in PQ can also do a great job!

[@AccessAnalytic]

Ah yeah column from examples is very cool

[@ThePattersonPod]

Awesome! Haven’t used it much in Power Query yet, but I look forward to it

[@AccessAnalytic]

I appreciate you taking the time to let me know you found it useful

[@4luvofgod]

I can't remember all of these shit 😅😮😂

[@AccessAnalytic]

😵‍💫

[@daazmo]

Great video! But still trying to find an answer to a situation I have. I have a bunch of tax codes in one column and matching cost ex gst. I want to add a column including 10% gst if that value has a specific tax code, else it does not inherit 10% gst and should populate the cost ex gst value.

[@AccessAnalytic]

Seems like should be a case of using the custom column button. If tax code column = X then value column x 0.1 else value column

[@daazmo]

Thank you! I was so close originally, but yet so far.@@AccessAnalytic

[@PavanKumarNarbolikar]

We could simply filter. Unless filter criteria is dynamic

[@AccessAnalytic]

Yeo true for this simple demo. But can you do a filter if EITHER (OR) are true because if filtering columns one at a time you are really doing AND filter.

[@PavanKumarNarbolikar]

​@@AccessAnalytic true that..

[@AccessAnalytic]

Just edited my reply as I realised I got it mixed around the wrong way and you are correct in the AND case filter

[@haneefksiddiq8500]

Good information bozz

[@AccessAnalytic]

Thanks