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"...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    The expression below will always return False.

    AND ( ( Detail[Period: Start Date] <= NOW () ), "0" )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Anonymous,

 

The expression below will always return False.

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