Forum Discussion
Solved
Creating Week Range With Leading 0's
Hello, I am trying to create a week range column in my date table. I got the start and end date columns in Power Query, changed their format to mm/dd/yyyy in Table view, and concatenated them but the...
Hi,
If you are OK with a DAX solution, then write this calculated column formula
Week range = format(Data[Start of week],"mm/dd/yyyy")&"-"&format(Data[End of week],"mm/dd/yyyy")
Hope this helps.
hello bernate
for leading zero, can you please change mm to MM.
for the ordering ,
i would suggest to create a start of week column, and sort the week range by this column.
let me know if this would help you .
best regards