Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

IF And Statment

Hi ,

 

I am trying to do an If and, here is what i have done in BI, but it dose not give me any value so i am guessing it wrong.

 

YTD SAVINGS =
IF(AND((Detail[Period: Start Date] <= NOW()), "0"),

IF(AND(Detail[Period: Start Date] <= NOW(), Benefits[Stage] = "Operate"),Detail[Savings Amount])
)

 

Any help will be great.

 

Thanks

  • Anonymous,

     

    The expression below will always return False.

    AND ( ( Detail[Period: Start Date] <= NOW () ), "0" )

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    Anonymous,

     

    The expression below will always return False.

    AND ( ( Detail[Period: Start Date] <= NOW () ), "0" )