Forum Discussion
SpiroswayGR
Resolver III
Resolver IIICustom Week Number for specific Date Range
Dear Community, I would like to create a weeknumber for specific date range in 2 years : Example : Start Date : 01/06/2019 to End Date : 05/11/2020 01/06/2019 to 07/06/2019 is Week1 08/06/2...
Like
Week = format([Week Start date],"dd/mm/YYYY") & " to "& format([Week End date],"dd/mm/YYYY")If you need set that as date format : https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712
Greg_Deckler
Community Champion
Community ChampionCheck out Sequential - https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231#M116
SpiroswayGRResolver III
Resolver IIIGreg_Deckler Looks like that i need sequential solution.
With this calendar table is possible to create sequential measure / column ?
- Greg_DecklerSpiroswayGR Yes, just start by creating columns for Year=YEAR([Date]) and Week=WEEKNUM([Date])