Hi All,

I'm looking for some help converting an excel formula im using (that works perfectly fine) to a Power query formula. I have decided a power query will better suit my data outcome so want to move across but obviously the language is different and I cant work out how to convert it. here is my normal excel formula:

=IF([@Duration]="","0",IF([@Duration]=0,"0",IF(LEFT([@Duration],4)="0.50",0.5,1)))
Its a nice simple IF statement that includes a LEFT function.

Hope someone can help convert it into a power query formula.

Thanks in advance,