Removing Dates

[WHITE655]

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 of those. 

When I go to look at my data I am now getting a recored for everyday before 11/16/2021 and 1/26/2022. I am trying to just get the once recored with the my start and end date and remove the other rows. 

[v-janeyg-msft · Accepted solution]

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

[mh2587]

You can remove duplicates in Power Query by selecting the column right click then click on remove duplicates