Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
Iam trying to get week number for a datetime value using WEEKNUM function in power BI Desktop.
Issue: For the same datetime value , the function is giving different results.Could someone please help me how to rectify this?
Please look at the record in Red text.
BookingDate | bookingweek |
1/13/2018 0:00 | 2 |
1/13/2018 0:00 | 2 |
1/13/2018 0:00 | 2 |
1/13/2018 0:00 | 2 |
1/13/2018 0:00 | 4 |
1/13/2018 0:00 | 2 |
Any help is much appreciated!
Solved! Go to Solution.
Hi Xiaoxin Sheng,
Thanks for your time , I really appreciate it.
The issue is resolved and evrything is working fine now.I dont know what the issue was , but when I tried couple of times it came out correctly.
I cannot send the pbix file as well, because that has been corrected and I dont have the old data.
Thanks
Lavanya
Hi @lavanyak,
I test with same date but not face the issue, can you please share a same pbix file to test?
Regards,
Xiaoxin Sheng
Hi Xiaoxin Sheng,
Thanks for your time , I really appreciate it.
The issue is resolved and evrything is working fine now.I dont know what the issue was , but when I tried couple of times it came out correctly.
I cannot send the pbix file as well, because that has been corrected and I dont have the old data.
Thanks
Lavanya
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |