Forum Discussion

g-wizard's avatar
g-wizard
Frequent Visitor
2 years ago
Solved

Month to MFG Calc

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

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    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
)

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    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
)