Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Not equal

Hi good day,  Can anyone help me on how to simplify the part of my calculated column. The Bold and underline portion   Forecast = FILTER(SUMMARIZE('Data', 'Data'[Date], 'Data'[Subcon], 'Data'[...
Need Help
  • vojtechsima's avatar
    vojtechsima
    1 year ago

    Hey man, AllanBerces 

    use the same IN approach like above, just with NOT operator:

    Forecast =
FILTER (
    SUMMARIZE (
        'Data',
        'Data'[Date],
        'Data'[Subcon],
        'Data'[TA],
        'Data'[WNT],
        "ForecastHrs", CALCULATE ( SUM ( 'Data'[ForecastHrs] ) ),
        "Hoursperday", CALCULATE ( SUM ( 'Data'[Hours Per day] ) )
    ),
    [Subcon] IN { "A", "B", "C" }
        && [TA] = "TA25"
        && NOT ( [WNT] IN { "FA5", "EG1", "Asset" } )
)
vojtechsima's avatar
vojtechsima
Super User
1 year ago

Hey man, AllanBerces 

use the same IN approach like above, just with NOT operator:

Forecast =
FILTER (
    SUMMARIZE (
        'Data',
        'Data'[Date],
        'Data'[Subcon],
        'Data'[TA],
        'Data'[WNT],
        "ForecastHrs", CALCULATE ( SUM ( 'Data'[ForecastHrs] ) ),
        "Hoursperday", CALCULATE ( SUM ( 'Data'[Hours Per day] ) )
    ),
    [Subcon] IN { "A", "B", "C" }
        && [TA] = "TA25"
        && NOT ( [WNT] IN { "FA5", "EG1", "Asset" } )
)
AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago

Hi vojtechsima thank you very much for the reply. working as i need.