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 , 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