Forum Discussion

setis's avatar
setis
Icon for Post Partisan rankPost Partisan
6 years ago
Solved

IF and SELECTEDVALUE with multiple conditions

Dear experts, I have the following issue.  I have a slicer with several elements. When 2 specific elements are selected, I want a specific calculation and if they are not, I want another one.    ...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    Sorry i was abit to quick there! 🙂 

    IF(
AND(
        FIRSTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2B" ||
        FIRSTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2I" ;
        LASTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2B" ||
        LASTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2I" ) ;
        [Revenue] * [ExchRateCurrency];
        "" )
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

Sorry i was abit to quick there! 🙂 

IF(
AND(
        FIRSTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2B" ||
        FIRSTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2I" ;
        LASTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2B" ||
        LASTNONBLANK(G_L Entry'[BU];G_L Entry'[BU]) = "B2I" ) ;
        [Revenue] * [ExchRateCurrency];
        "" )
setis's avatar
setis
Icon for Post Partisan rankPost Partisan
6 years ago

tex628 Perfect. It works. Thank you so much!

MartynRamsden Thanks a lot for your help too.