Forum Discussion

amlopez45's avatar
amlopez45
Frequent Visitor
7 years ago
Solved

Incorrect output for IF function

Hi Everyone,    I am not sure what is going on with the IF function but it is not working as I would expected to. I want to get the number of days between two dates if a certain condition is met. I...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI amlopez45,

     

    Can you please share pbix file for test? Your formula works well on my side.

     

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hello amlopez45

 

first things first, try changing your data format (top of modeling tab) to date for your calculated column and see if that fixes your issue

 

here is a picture of what I did.

best regards,

Collin

amlopez45's avatar
amlopez45
Frequent Visitor
7 years ago

Hello Anonymous,

 

Thank you for the suggestion, the formula is working well now. :smileyhappy:

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    amlopez45

     

    Great to hear, be sure to mark the post as the solution for anyone else that comes along. 

     

    best Regards,

    Collin