Forum Discussion
Import files from folder but when the creation date matches a data in a custom calendar
Hello, I can import files from a folder and filter them based on its creation date etc. but I'd like to enhance it so that I filter out dates (dates are within the filename) that don't exist in a ca...
Hi Anonymous
Yes, you can extract the Date from filename first, then add another coloumn or you can use it within the same column to check with it is in the Calendar Date list. Make sure your date from filename has the same type/format with the Calendar Date. The CalendarDate here is my date list
Table.AddColumn(#"Added Custom", "Custom", each List.Contains(CalendarDate,[DateinFile]))
Hi Anonymous
Yes, you can extract the Date from filename first, then add another coloumn or you can use it within the same column to check with it is in the Calendar Date list. Make sure your date from filename has the same type/format with the Calendar Date. The CalendarDate here is my date list
Table.AddColumn(#"Added Custom", "Custom", each List.Contains(CalendarDate,[DateinFile]))
yes I did exactly that but slightly modified
if (List.Contains(BillingCalendar,[Date created])=true) then true else false