Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |