Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, Good day
I dont understand why WEEKNUM Function is not working (but is also working) in the same table in DirectQuery Mode?
Thanks
Solved! Go to 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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |