Hi everyone!
I'm just starting to work with Power BI.
In the desktop version, I've create new column (Calculated)
So what I need is to create a new column and put values acording to the first column.
ie:
Column A has numeric values, from 0 to 1000.
So I need to put in column B:
If Column A is lower than 500, put "Lower than 500", else "Higher than 500"
What I use is:
B = IF(Table[A]<500,"Lower than 500","Higher than 500")
But it doesn't work.
Any idea why?
