Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

IF

Hi to all,  Can someone help me to edit my measure to add IF condition from the current measure, I have a table with column of Week no. What i need is if the value is lessthan this week make it zero...
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    Hi AllanBerces ,

    You can achieve the desired result by using this DAX:

    _5 Delta PY Line Negative AC =
VAR CurrentWeek = MAX(DateTable[Week No])  -- Get the current week number
RETURN
    IF(
        MAX(DateTable[Week No]) < CurrentWeek,  -- Check if the week is less than the current week
        0,  -- Set the value to zero
        IF(
            [_5 Delta PY] < 0, 
            [_5 Delta PY Line] + [_5 Delta PY], 
            BLANK()
        )
    )
Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

Hi AllanBerces ,

You can achieve the desired result by using this DAX:

_5 Delta PY Line Negative AC =
VAR CurrentWeek = MAX(DateTable[Week No])  -- Get the current week number
RETURN
    IF(
        MAX(DateTable[Week No]) < CurrentWeek,  -- Check if the week is less than the current week
        0,  -- Set the value to zero
        IF(
            [_5 Delta PY] < 0, 
            [_5 Delta PY Line] + [_5 Delta PY], 
            BLANK()
        )
    )