Forum Discussion

New_be's avatar
New_be
Icon for Helper V rankHelper V
6 years ago
Solved

Calculated column to compare String & Date

Hi everyone, Refer to the subject, i have one question on how to make a condition for date that based on day.  For example in this case, i have a days column & a date_off column seperately. Days ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi New_be ,

     

    I think you can create a calculated column using the below DAX:

     

    column = if(Days = "Friday",DAY_OFF,BLANK())

     

    Please try.

    Aiolos Zhao

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi New_be ,

 

I think you can create a calculated column using the below DAX:

 

column = if(Days = "Friday",DAY_OFF,BLANK())

 

Please try.

Aiolos Zhao