Forum Discussion

EsterBR's avatar
EsterBR
Helper II
2 years ago

How to split quarters to weeks data

Hi,

 

I have the following table . Is there any way in Power Query or DAX to split this table in weeks? Thanks you so much!

 

Need Help

4 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Hi EsterBR 

    What do you mean by "split"?

    There are approximately 13 weeks in a quarter...

    The table in the attached image has one row per quarter...

    Is your goal to duplicate the row for each quarter by the number of weeks?

    • EsterBR's avatar
      EsterBR
      Helper II
      2 years ago

      Hi Ritaf1983 danextian, My goal is to change the granularity of the table to weeks in Power Query or Power BI. To get the sales per week I will divide the SUM of sales of the quarter divided by the number of weeks of the quarter.

      • danextian's avatar
        danextian
        Super User
        2 years ago

        But how many weeks in quarter? Do you count the number of days divided by 7? Roundup or rounddown? Or do you count a particular day, say Monday?

  • danextian's avatar
    danextian
    Super User
    2 years ago

    This is simple in Power Query but how many weeks. They don't all have the same number of weeks and do you intend to split the amount as well?