topic Re: Restrictions to LOOKUPVALUE in DAX Commands and Tips

Restrictions to LOOKUPVALUE

aiplbonn — Wed, 01 Feb 2023 14:48:22 GMT

Hi,

to calculate the tax (mwst) in an order table, i have created a tax (mwst) table with the matching country code.

MWST = LOOKUPVALUE(Mwst[VAT Regular],MWST[land],OrderData[land],1)

But now I need another restriction.

If the field class in the table OrderData contains the word "special", the field "VAT Special" should be used in the VAT table instead of the field VAT Regular.
If the field class contains something other than "special", then simply "VAT Regular".

In Speudo code like this.

if(OrderData[class]= special)

LOOKUPVALUE(Mwst[VAT Special],MWST[land],OrderData[land],1)

else

LOOKUPVALUE(Mwst[VAT Regular],MWST[land],OrderData[land],1)

But i have no idea how to do this the rigth way.

Re: Restrictions to LOOKUPVALUE

FreemanZ — Wed, 01 Feb 2023 15:06:15 GMT

hi aiplbonn

try like:

MWST =

VAR _special =

LOOKUPVALUE(

Mwst[VAT Special],

MWST[land],

OrderData[land],

)

VAR _regular =

LOOKUPVALUE(

Mwst[VAT Regular],

MWST[land],

OrderData[land],

)

RETURN

IF(

CONTAINSSTRING(OrderData[class], "special"),

_special, _regular

)

Re: Restrictions to LOOKUPVALUE

aiplbonn — Wed, 01 Feb 2023 15:14:57 GMT

hi FreemanZ

this works perfectly! Thank you so much!