Results 1 to 4 of 4

Thread: Bins starting on the wrong date

  1. #1
    Seeker lmk001's Avatar
    Join Date
    Apr 2020
    Posts
    5
    Articles
    0
    Excel Version
    OFFICE 365

    Bins starting on the wrong date



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	RNought Bin Starting on wrong date table and bin window.jpg 
Views:	9 
Size:	79.7 KB 
ID:	9811   Click image for larger version. 

Name:	RNought Bin Starting on wrong date table visual.JPG 
Views:	6 
Size:	24.7 KB 
ID:	9812  

  2. #2
    Conjurer NormS's Avatar
    Join Date
    Jul 2017
    Posts
    119
    Articles
    0
    Excel Version
    Excel 2016 ProPlus
    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/pow...ng-and-binning

  3. #3
    Seeker lmk001's Avatar
    Join Date
    Apr 2020
    Posts
    5
    Articles
    0
    Excel Version
    OFFICE 365
    I have Office 365. I don't want my dates to change. This must be a bug

  4. #4
    Seeker lmk001's Avatar
    Join Date
    Apr 2020
    Posts
    5
    Articles
    0
    Excel Version
    OFFICE 365
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •