Forum Discussion

ligalbert's avatar
ligalbert
Icon for Helper I rankHelper I
4 years ago

How can I create a week to week date

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 

  

Need Help
Show and Tell

1 Reply

  • Seanan's avatar
    Seanan
    Icon for Solution Supplier rankSolution Supplier
    4 years ago

    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.