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

MattAllington's avatar
MattAllington
Community Champion
9 years ago

Power Pivot is very different to Excel, and it is very common for Excel Pros to take an approach like this. But I am almost certain there is a better way to do what you want. It looks like you only have a single table. If you want to know day names, the. You should load a calendar table, create a relationship, and use the day name from the calendar table. http://exceleratorbi.com.au/power-pivot-calendar-tables/

 

Your VLOOKUP question is also probably the wrong question.  Can you describe your data and what you want to achieve?