Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Need help me, please!
I'm trying to create a calendar with the start of the week on Sunday and the first week of 2022 should start on January 02, 2022, respectively, January 1, 2022 should fall in the last week of 2021, but something goes wrong(
Solved! Go to Solution.
Hi,
Something like this should work:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi,
Something like this should work:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi ValtteriN,
great solution, thanks for sharing.
I suppose this new field has data type "text"?
I am wondering if there is a way to put this field (you explained) into a filter with Slicer settings "between".
Thanks in advance
ssz
Hi,
Text type data can't be put to a between slicer. In that caseyou can format your year + weeeknum as a number e.g. 202301, 202302, 202303 and the put this into a slicer.
Proud to be a Super User!
Thanks again, ValtteriN. This what I did. Unfortunately the slicer automatically filled all blank values between the min and max value.
This leads to [YearWeek] fields like 202260, 202270, 202299...
Is there anyway to only display existing values in slicer element.
Thanks
ssz
Hi @ValtteriN
Could you help me figure out how to calulate week number based on a particular date column in my dataset? My week is also supposed to start from sunday unlike the conventional week. Thanks in advance!
@Anonymous , Sunday week start and end
Week Start date = [Date]+-1*WEEKDAY([Date],1)+1
Week End date = [Date]+ 7-1*WEEKDAY([Date],1)
Week num = weeknum([Date],1)
year Week num = year([Week Start date] ) *100 + weeknum([Date],1)
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |