Power Query AntiLog 10 function

[peter789]

Is there a function in PowerQuery to return the antilog base 10 of a number please? I cannot seem to find the ^ operator either to do it the normal way.

Thanks
Peter

 

[peter789]

I'll answer my own question.
It was staring me in the face!

= Table.AddColumn(#"Changed Type", "Inserted Power", each Number.Power(10,[#"Column_Name"]), type number)

Easy way to do is add column; custom calculation; raise to power 10.

= Table.AddColumn(#"Changed Type", "Inserted Power", each Number.Power([#"column_Name"], 10), type number)

Then swop 10 and Column_Name.

Peter

P.S. Sorry for wasting anyone's time.