Forum Discussion

BGuttmann's avatar
BGuttmann
Regular Visitor
9 years ago
Solved

2 DAX Questions

Hi, I am trying to figure out where I am going wrong with the below DAX Expression    =IF(AND(YEAR([Demand Sent]=YEAR(TODAY())),WEEKNUM([Demand Sent]=WEEKNUM(TODAY())),FORMAT([Demand Sent],"ddd"),"...
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi BGuttmann,

     

    If you need check the year, you can use YEAR function.
    Column = IF(WEEKNUM(Table1[Date])=WEEKNUM(TODAY())&&YEAR(Table1[Date])=YEAR(TODAY()),,SWITCH(WEEKDAY(Table1[Date]),1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5,"Thursday",6,"Friday",7,"Saturday"),"Other Week")

     

    And the week is start from Sunday.

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi BGuttmann,

 

To return weekday name if the date belong to current week, you can use the DAX below.
Column = IF(WEEKNUM(Table1[Date])=WEEKNUM(TODAY()),SWITCH(WEEKDAY(Table1[Date]),1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5,"Thursday",6,"Friday",7,"Saturday"),"Other Week")

 

Regards,

Charlie Liao

BGuttmann's avatar
BGuttmann
Regular Visitor
9 years ago

Hi - I just noticed that I dont think this is checking to make sure that the date is also from the current year - only the current week - how can I add that in? Also, is the "Current Week" being calculated for Monday - Sunday?

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    Hi BGuttmann,

     

    If you need check the year, you can use YEAR function.
    Column = IF(WEEKNUM(Table1[Date])=WEEKNUM(TODAY())&&YEAR(Table1[Date])=YEAR(TODAY()),,SWITCH(WEEKDAY(Table1[Date]),1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5,"Thursday",6,"Friday",7,"Saturday"),"Other Week")

     

    And the week is start from Sunday.

     

    Regards,

    Charlie Liao