Forum Discussion

SheldonEdwards's avatar
SheldonEdwards
Advocate I
8 years ago
Solved

WEEKNUM Function not working in DirectQuery Mode

Hi, Good day   I dont understand why WEEKNUM Function is not working (but is also working) in the same table in DirectQuery Mode?   Thanks  
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

     Hi SheldonEdwards,

     

    Based on my research test, it seems to be that WEEKNUM function won't work with return_type 2 with Direct Query mode currently. It works fine with retrun_type 1, and 21.

    Week = WEEKNUM(Date[Date],1)
    Week = WEEKNUM(Date[Date],21)

    In addition, here is a similar thread for your reference. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

 Hi SheldonEdwards,

 

Based on my research test, it seems to be that WEEKNUM function won't work with return_type 2 with Direct Query mode currently. It works fine with retrun_type 1, and 21.

Week = WEEKNUM(Date[Date],1)
Week = WEEKNUM(Date[Date],21)

In addition, here is a similar thread for your reference. :smileyhappy:

 

Regards