Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Semantic Error: The function SUM takes an argument that evaluates to numbers or dates and cannot wor

Hi all,

 

I am using excel as datasource, but sometimes when one numeric column comes empty (blank()), power pivot is converting the column to text becasue there is no data in there. 

Is there any way to fix the column format to number?

 

Gilly

 

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    In PowerQuery you can change the data type of a column that you are loading.  PowerQuery tries to make a guess but sometimes can't determine.

  • Anonymous's avatar
    Anonymous
    7 years ago

    We can do the same in Power Pivot changing the data type, I have found a way to swtich to zero when the column is blank sorting the issue out.

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    7 years ago

    In PowerQuery you can change the data type of a column that you are loading.  PowerQuery tries to make a guess but sometimes can't determine.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      We can do the same in Power Pivot changing the data type, I have found a way to swtich to zero when the column is blank sorting the issue out.