To the Power ^ in M (Power BI)

Question

I creating a custom column in Power BI

= Table.AddColumn(Fact_Sale, "Custom", each 2^[Sale Key] , type number)`

I tried using ^ to represent the power operator but got an eerror

I tried to google but the when I search for the power operartor all i get is Power Query (same names making it hard to search)

I found this but thre was nothing for hte power operator https://msdn.microsoft.com/en-us/query-bi/m/operators

how can I do it?

"I got an error". Which one? Where? Is there a reason it isn't it in your question? — Jongware, Jul 22 '18 at 12:14

score 1 · Accepted Answer · answered Jul 22 '18 at 11:58

1

Power is implemented as a function, not as an operator.

Number.Power(2, 3) will give you 8

answered Jul 22 '18 at 11:58

RADO

1 Answers1