Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Icon for Helper V rankHelper V
4 years ago
Solved

IF OR Dax help

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

Need Help
  • mwegener's avatar
    mwegener
    4 years ago

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

     

3 Replies

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    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's avatar
      PowerBIBeginer
      Icon for Helper V rankHelper V
      4 years ago

      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's avatar
        PowerBIBeginer
        Icon for Helper V rankHelper V
        4 years ago

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