Forum Discussion

SM_1997's avatar
SM_1997
New Member
6 years ago
Solved

Creating a new column with multiple conditions

Hello! I am brand new to dax. I am trying to create a column that will return the machineid if status does not equal 3 and last change status date is the maximum.

 

I was able to get it to work for the last change status date but when I try to add in the status part via AND I am getting an error.

 

Can anyone possibly help me? Please let me know if you need more detail.

 

My Table/Command

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    HI SM_1997 ,

     

    Use && instead of AND.

     

    Regards,

    Harsh Nathani

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI SM_1997 ,

     

    Use && instead of AND.

     

    Regards,

    Harsh Nathani

  • Anonymous's avatar
    Anonymous
    Not applicable

    what do you mean by  "last change status date is the maximum."