Forum Discussion

AKARSEVGI's avatar
AKARSEVGI
Helper I
4 years ago
Solved

IF STATEMENT

Could someone control this screen shot and fix it?

Need Help
  • mwegener's avatar
    mwegener
    4 years ago

    Hi AKARSEVGI ,

     

    try this

     

    UNITLISTPREUR =
IF (
    'SHEAD-SALHEAD'[DOCTYPE] IN { "FA", "FB", "FF" },
    RELATED ( 'PPRICE-PLTMATP'[PRICE1] ),
    IF (
        'SHEAD-SALHEAD'[DOCTYPE] IN { "FM", "FG" },
        RELATED ( 'PPRICE-PLTMATP'[PRICE4] )
    )
)

     

1 Reply

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    4 years ago

    Hi AKARSEVGI ,

     

    try this

     

    UNITLISTPREUR =
IF (
    'SHEAD-SALHEAD'[DOCTYPE] IN { "FA", "FB", "FF" },
    RELATED ( 'PPRICE-PLTMATP'[PRICE1] ),
    IF (
        'SHEAD-SALHEAD'[DOCTYPE] IN { "FM", "FG" },
        RELATED ( 'PPRICE-PLTMATP'[PRICE4] )
    )
)