Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I created a new table and apply calendar formula to generate date:
CALENDAR(DATE(2017,01,01),DATE(2017,12,31))
Is there any function to show the Week of Month using dax language?
What I mean by Week of Month is for example: 1 Jun 2017 is considered as Week 1 (in month of June)
Regards,
Solved! Go to Solution.
Hi @RMV,
You can simple add a calculated column to calculate the week of month: (use current week number - month start week number)
Week of Month = var currentweek=WEEKNUM([Date],1) var startWeek=WEEKNUM(DATE([Date].[Year],[Date].[MonthNo],1),1) return Currentweek-startWeek+1
Regards,
Xiaoxin Sheng
Hi @RMV,
You can simple add a calculated column to calculate the week of month: (use current week number - month start week number)
Week of Month = var currentweek=WEEKNUM([Date],1) var startWeek=WEEKNUM(DATE([Date].[Year],[Date].[MonthNo],1),1) return Currentweek-startWeek+1
Regards,
Xiaoxin Sheng
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |