Forum Discussion

WHITE655's avatar
WHITE655
Regular Visitor
4 years ago
Solved

Removing Dates

I am struggling to remove dates.    I have a start date of 11/16/2021 - end date of 1/26/2022. I created a list of dates colume and then added a table calendar and created a relationship with both ...
  • v-janeyg-msft's avatar
    4 years ago

    Hi, WHITE655 

     

    The dates in the calendar table are all continuous.

    If you only want to display the dates in the original table, you can create a table.

    like this:

    table2 = VALUES ( table1[Date] )
    

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey