Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have the following business case, please help me to solve it.
I would like to create a dimension (x axis for example in a line chart) and show each weeknumber inside the month.
Number of the weeks should have to restart in every month.
I have a date field like 2017.01.02 (YYYY.MM.DD)
I would like to get, for example 201701W1 201701W2 201701W3 .... 201702W1 ...201702W4.....201703W1.
Thanks,
Daniel
Solved! Go to Solution.
Hi @DanielDArtist,
You can try to use below formula to show the formatted date.
Calculate column:
Week = FORMAT([Date],"yyyymm")&"W"&WEEKNUM([date],1)-WEEKNUM(DATE([date].[Year],[date].[MonthNo],1),1)+1
Regards,
Xiaoxin Sheng
Hi @DanielDArtist,
You can try to use below formula to show the formatted date.
Calculate column:
Week = FORMAT([Date],"yyyymm")&"W"&WEEKNUM([date],1)-WEEKNUM(DATE([date].[Year],[date].[MonthNo],1),1)+1
Regards,
Xiaoxin Sheng
The DAX formula you need is: Year([Date])&FORMAT([Date],"MM")&WEEKNUM([Date],2)
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |