How can I create a week to week date

[ligalbert]

I want to transform the date from powerbi to a week to week date as seen in the picture. Is there anyway I can do that 

  

[Seanan]

Hi @ligalbert 

You could do something quick and simple like creating a bin for your dates. to do this navigate to the Fields pane on the right hand side -> click on the 3 dots next to your dates column -> click new group and then set the bin size to 7 days

It may be worth creating a new dates table incasse any of your data is missing a day. To do this click new table then use the following code (You can change the start and end date to any range you like)

Dates = CALENDAR("01-01-2020","01-01-2025")

Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.