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 ma...
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
)
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
)