Forum Discussion

nickspizza's avatar
nickspizza
Icon for Helper I rankHelper I
5 years ago
Solved

Create new column with integer values

I created new columns from if/then/else formulas where the output is either a number or null, but I can't aggregate them without getting an error saying that this new column that I'm trying to aggreg...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    nickspizza , Make sure data type of this column is numeric like whole number or decimal in power query

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

nickspizza , Make sure data type of this column is numeric like whole number or decimal in power query

  • nickspizza's avatar
    nickspizza
    Icon for Helper I rankHelper I
    5 years ago

    Okay thank you. I didn't know that you need to manually choose the data type for every column after creating it in Transformation. It seems to work