Forum Discussion

jadewind's avatar
jadewind
Icon for Advocate I rankAdvocate I
10 years ago

Power BI cannot apply operator & to numbers?

I was following this article but when it comes to this part adding a new column: "YearQuarter = IF([Quarter] = 1,[Year]-1 & "4",[Year] & [Quarter]-1)" I get errors: "Expression.Error: The name 'IF' w...
Need Help
ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

jadewind If you want to do via query editor then similar output of can be achieved by using Conditional column. So in query editor under Add Column tab add conditional column.

jadewind's avatar
jadewind
Icon for Advocate I rankAdvocate I
10 years ago

Thanks ankitmatira for your reply. I did try the conditional column but I can not perform the calculation. The "Output" will have to be either an entered value (text or number) or "Select a column" where I am not able to add "+1".