Error of variable DAX with scalar value in Excel 2013

[PietroFarias]

I am adjusting some syntax so it can be read in Excel 2013. There were two errors found in Excel 2013, the first one was referring to 'IN' (already solved in another post Post609960), and another referring to variables. As you can see in the image below.

I work with many variants, and the errors occurred exactly in the two variances that I used to return a specific value.

VAR TipoServ = "Service"
VAR EmpresaServ = "Company"

Is there an error with these variables in Excel 2013?

[v-yulgu-msft · Accepted solution]

Hi @PietroFarias,

I tested with Excel 2016 with a simple DAX formula, no error message was prompted.

Measure1:=var var1="Service"
return
var1

It might be a limitation of the Excel version. But you can also test with above simple formula in your Excel to test if it works. If it still doesn't work, you may need to update your excel version. If it works, please share the whole DAX formula you used.

Regards,

Yuliana Gu

[PietroFarias]

forI belive be a limitation of the Excel version. I change the formula for work 2013. Thanks.