Forum Discussion
New_be
Helper V
Helper VCalculated 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 column in text type while date_off column is a date type.
I want to make a condition like, return date_off if days <> "Friday". This column will return date_off for every days except from "Friday". Thanks in advance
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
