topic Re: replace cell value with conditional value and multiply to output value in DAX Commands and Tips

replace cell value with conditional value and multiply to output value

Anonymous — Fri, 17 Jun 2022 11:06:08 GMT

Hello all,
I am new to power bi and need help with a calculation.

I have three columns: "Anzahl Lieferanten", "Anzahl Hersteller" and "Zeit bis EOL" (in days). Now I want to assign a value from 1-3 to each of the values in the columns if they are greater or less than certain values. the resulting values I then want to multiply.
I have thought of something like this:

Of course, it doesn't work that way. Maybe someone can help me? Thanks in advance!

Re: replace cell value with conditional value and multiply to output value

tamerj1 — Fri, 17 Jun 2022 12:39:03 GMT

Hi Anonymous
You missed the ( , ) after TRUE ( ) in the first variable. Also delete the ( " " ) from around the numbers. Eg. write 1 not "1"

Re: replace cell value with conditional value and multiply to output value

rohit_singh — Fri, 17 Jun 2022 12:55:46 GMT

Hello Anonymous ,

The issue is with the syntax of the switch statement.

Obsoleszenzwahrscheinlichkeit =

var Lieferantenrisiko =

SWITCH(

TRUE(),

Inventory[Anzahl Lieferanten] = 1, 3,

Inventory[Anzahl Lieferanten] > 1 && Inventory[Anzahl Lieferanten] < 4, 2,

Inventory[Anzahl Lieferanten] > 3, 1

)

var Herstellerrisiko =

SWITCH(

TRUE(),

Inventory[Anzahl Hersteller] = 1, 3,

Inventory[Anzahl Hersteller] > 1 && Inventory[Anzahl Hersteller] < 4, 2,

Inventory[Anzahl Hersteller] > 3, 1

)

var EOLRisiko =

SWITCH(

TRUE(),

Inventory[Zeit bis EOL] < 365, 1,

Inventory[Zeit bis EOL] >= 365 && Inventory[Zeit bis EOL] <= 730, 2,

Inventory[Zeit bis EOL] > 730, 3

)

var result =

(2 * Lieferantenrisiko) * Herstellerrisiko * EOLRisiko

Return

result

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Re: replace cell value with conditional value and multiply to output value

Anonymous — Fri, 17 Jun 2022 15:33:17 GMT

Thank you so much Rohit!

Now it works perfectly 🙂