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?

 

WEEKNUM Function working perfectly

WEEKNUM Function not workingBoth WEEKNUM Functions exist in same table

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

1 Reply

  • 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