Forum Discussion

VoltesDev's avatar
VoltesDev
Icon for Helper V rankHelper 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
VoltesDev's avatar
VoltesDev
Icon for Helper V rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper V rankHelper 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
      Icon for Community Support rankCommunity 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