Forum Discussion

EsterBR's avatar
EsterBR
Icon for Helper II rankHelper 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
EsterBR's avatar
EsterBR
Icon for Helper II rankHelper 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
Icon for Super User rankSuper 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?