WEEKNUM Function not working in DirectQuery Mode

[SheldonEdwards]

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

[v-ljerr-msft · Accepted solution]

 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. 

Regards