IF OR Dax help

[PowerBIBeginer]

Hi All,

I need help in designing below dax. This i'm tryig to do, can anyone help on this

HoursA =
IF(OR( Active[Month]=11, Active[Month]=12),
IF( Active[Active Status]=1,
IF('Active'[Center]="Mum",480*'Active'[Prod],450*'Active'[Prod]),

IF(OR( Active[Month] other than 11 and 12 month) then
IF( Active[Active Status]=1, IF('Active'[Center]="Mum",465*'Active'[Prod],435*'Active'[Prod]),0)
)))

[mwegener · Accepted solution]

Hi @PowerBIBeginer 

hard to tell what conditions you really wanted, I derived this one.

HoursA =
IF (
    OR ( Active[Month] = 11, Active[Month] = 12 ),
    IF (
        Active[Active Status] = 1,
        IF ( 'Active'[Center] = "Mum", 480 * 'Active'[Prod], 450 * 'Active'[Prod] ),
        0
    ),
    -- Active[Month] other than 11 and 12 month
    IF (
        Active[Active Status] = 1,
        IF ( 'Active'[Center] = "Mum", 465 * 'Active'[Prod], 435 * 'Active'[Prod] ),
        0
    )
)

[PowerBIBeginer]

Hi superuser, Thanks for your prompt reply. what I'm trying to do is, if month = 11 or 12 (11 is Nov and 12 is Dec), then below line should work-

Active[Active Status] = 1, IF ( 'Active'[Center] = "Mum", 480 * 'Active'[Prod], 450 * 'Active'[Prod] ),

else, if month is other than 11 or 12 (i.e. 1 or 2 or 3 / 4 / 5 /6/7/8/9/10) means from Jan till Oct then below code work..

Active[Active Status] = 1, IF ( 'Active'[Center] = "Mum", 465 * 'Active'[Prod], 435 * 'Active'[Prod] ),

I'm getting values for months 11 or 12 correctly but for other moths I'm getting 0.  

[PowerBIBeginer]

Hey Hi mwegener (super user), you're correct. your solution is correct, just got that what you've given me.. Great. Thank You so much..