Forum Discussion

mdbuzzer's avatar
mdbuzzer
Icon for Helper I rankHelper I
5 years ago
Solved

Why is weekly grouping returning wrong dates?

I am creating bins based of my Date field. I created two bins, one which retrieves the daily bins whilst the other bin is to return weekly dates. The daily bins returns the correct dates but the week...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi mdbuzzer ,

     

    After my researching, it is by design. Binning splits numeric or date/time data into equally sized groups. If we expand the date range a bit, you will find that October 1, October 2, and October 3 belong to the group beginning on September 27.

     

    You could learn more from: 

     

    https://dataveld.com/2018/05/10/manual-groups-bins-power-bi/

     

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi mdbuzzer ,

 

After my researching, it is by design. Binning splits numeric or date/time data into equally sized groups. If we expand the date range a bit, you will find that October 1, October 2, and October 3 belong to the group beginning on September 27.

 

You could learn more from: 

 

https://dataveld.com/2018/05/10/manual-groups-bins-power-bi/

 

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.