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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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