Forum Discussion
Solved
Get correct file in the folder
Hi folks! I have an API that gives me one file per day with all ticket information of the month, so, on day 1 I have only records for 1 day, and day 30 I have all tickets of the month. I have...
Hi folks!
I've got what I wanted this way:1. Orderd the data from "Date"
2. Created a column with rank (0..N)
3. Created a condicional column that check if the file date is the last of the month OR rank = 0
4. Filtered true columns
#"Personalização Adicionada1" = Table.AddColumn(#"Colunas Renomeadas3", "LastDayMonthOrFirstLine", each if [Date created] = Date.EndOfMonth([Date created]) or [Rank] = 0 then 100 else 0)Tks for the helping!
Hi folks!
I've got what I wanted this way:
1. Orderd the data from "Date"
2. Created a column with rank (0..N)
3. Created a condicional column that check if the file date is the last of the month OR rank = 0
4. Filtered true columns
#"Personalização Adicionada1" = Table.AddColumn(#"Colunas Renomeadas3", "LastDayMonthOrFirstLine", each if [Date created] = Date.EndOfMonth([Date created]) or [Rank] = 0 then 100 else 0)
Tks for the helping!