Forum Discussion

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

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.

4 Replies

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
  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
    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.