Forum Discussion

brockry1's avatar
brockry1
Icon for Helper II rankHelper II
1 year ago
Solved

Growth % DAX Command

I'm trying to place a conidional DAX formula to show if the prior year is 0 then show 100% growth other wise divide the current year/prior year -1.     When I add the clause "If(Prior Year) isblank...
  • brockry1's avatar
    brockry1
    1 year ago
    Growth % =
    IF(
            OR(
                [Prior Year] > 0,
                ISBLANK([Prior Year])
            ),
     
            DIVIDE(
                [Current Year] - [Prior Year],
                [Prior Year],
                1
            )
        )
     
brockry1's avatar
brockry1
Icon for Helper II rankHelper II
1 year ago
Growth % =
IF(
        OR(
            [Prior Year] > 0,
            ISBLANK([Prior Year])
        ),
 
        DIVIDE(
            [Current Year] - [Prior Year],
            [Prior Year],
            1
        )
    )
 
brockry1's avatar
brockry1
Icon for Helper II rankHelper II
1 year ago

This was the formula that worked.