Forum Discussion
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 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.
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
2 Replies
- mh2587
Super User
You can remove duplicates in Power Query by selecting the column right click then click on remove duplicates
- v-janeyg-msft
Community Support
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
