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

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Community Support
        4 years ago

        Hi, VoltesDev 

         

        I couldn't get your reply. I don't know your specific situation.

        If you have solved the problem, welcome to share your thoughts.

        If you still need help, please feel free to ask me.


        Best Regards,
        Community Support Team _ Janey