Forum Discussion

VoltesDev's avatar
VoltesDev
Helper V
4 years ago

Non sequential date dimension

Hi friends,   I have a date dimension that has non sequential value : got 1 row  with date '1/1/1900' and then start with '1/1/2010' so forth until '12/31/2025' and then 1 other row with value '12/...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
4 years ago

VoltesDev , I would suggest moving all 1900 date to 2010 or make then null in power query and try

  • VoltesDev's avatar
    VoltesDev
    Helper V
    4 years ago

    Hi,

     

    I think I can't just change the date (move) since I'm using Direct Query, is there any other trick ?

    One of the reason is because in transaction, they do have transaction date of '01/01/1900'

    or should I use other DAX formula ?

     

    Thanks

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      VoltesDev , Table dates contain continuous dates from 2010 onward and are marked as date table ?

       

      I think you should get one blank record and the rest should work

      • VoltesDev's avatar
        VoltesDev
        Helper V
        4 years ago

        Hi,

         

        No, the date dimension is with '1/1/1900' for the 1st row, and then start with '1/1/2010' onward until 2025.

        I'm sorry, I didn't get what do you mean by blank record.

        Thanks