Bins starting on the wrong date

lmk001

New member
Joined
Apr 27, 2020
Messages
5
Reaction score
0
Points
0
Excel Version(s)
OFFICE 365
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.
 

Attachments

  • RNought Bin Starting on wrong date table and bin window.jpg
    RNought Bin Starting on wrong date table and bin window.jpg
    79.7 KB · Views: 16
  • RNought Bin Starting on wrong date table visual.JPG
    RNought Bin Starting on wrong date table visual.JPG
    24.7 KB · Views: 14
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
 
I have Office 365. I don't want my dates to change. This must be a bug
 
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.
 
Back
Top