Can i declare variable in Power Pivot??

[lavdeepk]

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]

Hi @lavdeepk 

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.

[lavdeepk]

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 · Accepted solution]

Hi @lavdeepk 

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.

[lavdeepk]

Hi @v-juanli-msft 

Thanks there was data type issue.Now Working fine

Thanks

Lavdeep