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.
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.
Worked perfectly, thank you for your help!