Display first date based on multiple if statements

Hello everyone, Question: How do I display the first Date using DAX when either Production A or Production B exceeds the values in the Forecast culumn? Thank you!

smpa01

4 years ago

queryuser you can use this measure

Measure =
MINX (
    CALCULATETABLE (
        VALUES ( 'Table'[Date] ),
        FILTER (
            'Table',
            VAR _prodA =
                CALCULATE ( SUM ( 'Table'[Prod A] ), ALLEXCEPT ( 'Table', 'Table'[Date] ) )
            VAR _prodB =
                CALCULATE ( SUM ( 'Table'[Prod B] ), ALLEXCEPT ( 'Table', 'Table'[Prod B] ) )
            VAR _forecast =
                CALCULATE ( SUM ( 'Table'[Forecast] ), ALLEXCEPT ( 'Table', 'Table'[Date] ) )
            RETURN
                _prodA > _forecast
                    || _prodB > _forecast
        )
    ),
    'Table'[Date]
)

_filterEachSide.pbix29 KB

Forum Discussion

Display first date based on multiple if statements

Related content

Multiple IF statements in DAX

Map displays multiple KPIs

Multiple nested IF statements

single dataset refresh, we observe multiple SQL statements

Multiple IF statements