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?