Forum Discussion

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 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

Tips and Tricks

Tutorial Requests

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

5 Replies

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
amitchandak
Super User
6 years ago
New_be , Try like

Weekday =WeekDay Name = FORMAT([Date],"dddd")

if(Weekday = WEEKDAY([Date],2) =5, "DAY_OFF",Blank())

if([Weekday] ="Friday", "DAY_OFF",Blank())

Any Weekday Week

ttps://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
V-lianl-msft
Community Support
6 years ago
Hi New_be ,

Try this calculated column
column = IF(Days <> "Friday",DAY_OFF,BLANK())

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- 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
    Helper V
    6 years ago
    Sorry i forgot to accept one of the answer as a solution. Thanks for your follow up 😊