Forum Discussion
Solved
Custom 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
amitchandak Thanks very much!!
Almost complete my solution but still 2 remaining things...
1st : Is it possible to show dates as "DD/MM/YYYY" instead of "MM/DD/YYYY"?
2nd : Is it possible to visualize on same weekly graph metrics for this week year and metrics for Last week year ?
for example : Week for this year : 10/02/2019 to 17/02/2019 with Sum metric = 1000 and last year metric : 10/02/2018 to 17/02/2019 with sum metric : 500
Thanks again!!
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