Month to MFG Calc

[g-wizard]

Hello Team,

I have difficulty on converting this calc that is pulling from 2 different tables:

IF [X-Plant Material Status]="50" THEN (12-(DATEDIFF('month',[Date from which the X-distr.-chain material status is valid (date)],TODAY())))
ELSEIF [X-Plant Material Status]="60" THEN (6-(DATEDIFF('month',[Date from which the X-distr.-chain material status is valid (date)],TODAY())))
ELSEIF [X-Plant Material Status]="65" THEN (6-(DATEDIFF('month',[Date from which the X-distr.-chain material status is valid (date)],TODAY())))
ELSEIF [X-Plant Material Status]="70" THEN 0
ELSEIF [X-Plant Material Status]="75" THEN 0
ELSEIF [X-Plant Material Status]="80" THEN 0
ELSEIF [X-Plant Material Status]="85" THEN 0 END

[Greg_Deckler · Accepted solution]

@g-wizard So, in DAX that would be:

SWITCH( [X-Plant Material Status],
 "50", (12-(DATEDIFF('month',[Date from which the X-distr.-chain material status is valid (date)],TODAY()))),
 "60", (6-(DATEDIFF('month',[Date from which the X-distr.-chain material status is valid (date)],TODAY()))),
 "65", (6-(DATEDIFF('month',[Date from which the X-distr.-chain material status is valid (date)],TODAY()))),
 "70", 0,
 "75", 0,
 "80", 0,
 "85", 0
)