Forum Discussion

chocomart's avatar
chocomart
Icon for Helper I rankHelper I
8 years ago

Doesn't display October 1, 2017 - error

I've just seen this recently, when I'm trying to add in the Start of Month field, and could not see Oct 1, 2017 on the list but instead Sept 30,2017 is displayed. Please see screenshot below, the tab...
v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

chocomart

 

Also you can use follow method to check if there exists duplicated dates in your calendar table.

 

 

If it returns blank. It means your calendar should work fine. And the issue may be related to the delay of visualization since there exists so may dates in table.

 

Thanks,
Xi Jin.

chocomart's avatar
chocomart
Icon for Helper I rankHelper I
8 years ago

Still having the same issue, has someone encountered the same?

  • Philthy's avatar
    Philthy
    Regular Visitor
    8 years ago

    Not quite the same issue, but something probably similar (I have a post titled "April Fools?" on here which goes into detail).

     

    Basically, my problem is I can filter my dashboard for ANY date, except 1 April, 2018.  When I try that in a filter, everything disappears, almost as if it doesn't exist (which seems remarkably similar to your problem, particularly as yours is also a quarter start date.

     

    I'm having to change my core SQL to create a derived field displaying the date in text (I'd rather do that than play with DAX in each PBIX file - easier doing it at source) and then update all my reports to use this field.  Frustrating.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Did you check if this issue would occur when using M language to create a calendar? You can refer to the following M script and create a calendar to see if you can get Oct 1.

     

    let
    start = #date(2010,1,1),
    end = #date(2018,12,31),
    CreateDateList = List.Dates(start, Number.From(Number.From(end)) - Number.From(start), #duration(1,0,0,0)),
    #"Converted to Table" = Table.FromList(CreateDateList, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Date"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type datetime}})
in
    #"Changed Type"