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 

How do you declare variable in Power Pivot?

Could you show me some examples with screenshots and tell me what's the errors?

Is this you wanted?

https://powerbi.tips/2017/05/using-variables-within-dax/

 

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