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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Maggie,

 

As reqired i am sharing details with you please see Below SS.

I am able to declare variable in power bi and getting error when i use same code and same syntex in power pivot

VAR EXAMPLE =
VAR
TotalQuantity = SUM (DATA[QTY] )
RETURN
IF (
TotalQuantity > 1000,
TotalQuantity * 0.95,
TotalQuantity * 1.25
)

 

 

Thanks 

Lavdeep sharma

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