Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
89
Views
Topic starter
As you can see on the meeting dates columns, there are two types of entries, either "specific dates" or "meeting 5 Times".
"Meeting 5 Times" means Mon/Tue/Wed/Thu/Fri, o I may keep them intact, as I know they are Mon/Tue/Tue/Thu/Fri.
How can I convert dates to weekdays? In this example, is it 8/9 and 8/10. There may be more entries coming with "specific dates" in addition to "Meeting 5 times".
Thanks!
Jim
Posted : 04/06/2023 10:18 pm
Hi Jim,
You can try this step:
= Table.TransformColumns(Source,{{"meeting_dates", each Text.Combine(List.Accumulate(Text.Split(_,","), {},(state, currentItem)=> state & { try Date.DayOfWeekName(Date.From(currentItem & "/2023")) otherwise currentItem } ), ","), type any}})
Posted : 06/06/2023 11:27 pm
