Forum Discussion

New_be's avatar
New_be
Helper 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

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi New_be ,

 

Is this problem sloved?
If not, please let me know.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

New_be's avatar
New_be
Helper V
6 years ago

Sorry i forgot to accept one of the answer as a solution. Thanks for your follow up ðŸ˜Š