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
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?