Forum Discussion

bnisbet's avatar
bnisbet
Frequent Visitor
9 years ago
Solved

IF Statement &&&&

Trying to use an IF Statement to calculate if a date is in the current month. When I take out "&&" it works fine, any ideas? Audit In Current Month = IF ( YEAR ( 'Power BI List'[Visit 1 Dat...
Need Help
Tips and Tricks
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi bnisbet,

     

    What error did you get?

     

    Based on my test, the formula you provided above should work.  :smileyhappy:

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi bnisbet,

 

What error did you get?

 

Based on my test, the formula you provided above should work.  :smileyhappy:

 

 

Regards