Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Can i declare variable in Power Pivot??

Hi, I am trying to declare variable in Power Pivot but getting error . I am not sure that i am making mistake or variable can not use in  Power Pivot?? Please help  
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    The error message indicates that the DATA[QTY] is of text type while it needs to be of number type.

    So, please check the type of that column and change it to number.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

The error message indicates that the DATA[QTY] is of text type while it needs to be of number type.

So, please check the type of that column and change it to number.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-juanli-msft 

 

Thanks there was data type issue.Now Working fine

 

Thanks

Lavdeep