power query (pbi)

Hi, Requesting assistance to convert the following Excel formulas in Power Query; = IF(AND([@CompleteDelivery]="N",[@OrderQty]=[@ConfirmedQty]),"Allocated", IF(AND([@CompleteDelivery]="N",[@ConfirmedQty]>0,[@ConfirmedQty]<[@OrderQty]),"Partially Allocated"...

I have a column with data like below A1000 ff, A2000 fs -7, A2010 ss -4 And so on. What I need is a query that will query the column and return a combined count of the occurrence of "fs -","ss -", "ff -", "sf -". Any help is much appreciated.

I have two queries where i can merge them with the "ID". The phase query has the phase ID, and the phase start and end date. The other query has hour values and a date value, and i want to add a column to this query with the Phase name, depending on which phase date range the date value is in...

Hi, Hopefully fairly simple question, how do I increase or at least zoom in on the formula bar in pq? I'm sure I've been able to do it but can't remember how? Richard.

So i'm stuck on this issue at the moment. Basically i want to structure data into phases, because the descriptions end dates doesn't fully represent when the phase officially ends, the phase ends when the next phase begins. I've tried to illustrate it here with some test data, left is how it...

Hi, I am new to Power Query and have an issue with a task which is relatively easy to complete in excel. I need to get a loop calculation where the next output is dependant on the previous output in two places. Please see below for a brief snapshot. The Starting point is 100 and no calculation...