Forum Discussion

bernate's avatar
bernate
Helper III
2 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi bernate ,

Below is my table:

The following DAX might work for you:

Week Range = COMBINEVALUES("-",FORMAT('Table'[StartOfWeek],"mm/dd/yyyy"),FORMAT('Table'[EndOfWeek],"mm/dd/yyyy"))

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.