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.
I have a requirement where i have a start and end date but here the month has to be 28 days and each month consists of 4 weeks.
Currently i have done this
but the problem here is, i am not able to reset the month or the week column i.e my weeknum should be 1,2,3,4,1,2,3,4 instead of 1,2,3,4,5,6,7,8..
Same goes with the month(Row number column) after the year end it should reset and start from 1.
Solved! Go to Solution.
@Anonymous I created this calendar for you in the attached PBIX file below signature. Here are some of the columns:
Sequential = COUNTROWS(FILTER('284Calendar',[Date]<=EARLIER([Date])))
FY = 2020 + TRUNC([Sequential]/364)
Month = TRUNC(COUNTROWS(FILTER('284Calendar',[Date]<EARLIER([Date]) && [FY] = EARLIER([FY])))/28) + 1
Week = TRUNC(COUNTROWS(FILTER('284Calendar',[Date]<EARLIER([Date]) && [FY] = EARLIER([FY]) && [Month] = EARLIER([Month])))/7) + 1
@Anonymous I created this calendar for you in the attached PBIX file below signature. Here are some of the columns:
Sequential = COUNTROWS(FILTER('284Calendar',[Date]<=EARLIER([Date])))
FY = 2020 + TRUNC([Sequential]/364)
Month = TRUNC(COUNTROWS(FILTER('284Calendar',[Date]<EARLIER([Date]) && [FY] = EARLIER([FY])))/28) + 1
Week = TRUNC(COUNTROWS(FILTER('284Calendar',[Date]<EARLIER([Date]) && [FY] = EARLIER([FY]) && [Month] = EARLIER([Month])))/7) + 1
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |