cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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

1 ACCEPTED SOLUTION
Super User

@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
)``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Super User

@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
)``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Announcements