PDA

View Full Version : Bins starting on the wrong date



lmk001
2020-05-19, 05:06 PM
I have a bin that is starting from 3/15/2020 when it should be starting from 3/17/2020. It increments the date every 14 days. I have attached a screenshot. I can't figure it out.

NormS
2020-05-20, 02:40 PM
Maybe there's an algorithm that determines the start date. For example, March 15 is a Sunday, maybe it picks the preceding Sunday. Or if you take the numeric representation of March 15, 43095, modulo 14, you get 1. If this is the rule changing the bin size to 15 should move the start to the 16th. The binning dialog shown in the Microsoft documentation looks different from the one you show; do you have the most recent version installed?

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

lmk001
2020-05-20, 03:28 PM
I have Office 365. I don't want my dates to change. This must be a bug

lmk001
2020-05-20, 03:49 PM
I updated to the latest version of Power BI and I still get the same problem. This must be a bug. I will have to use the Modulo workaround.