Count the number of dates in next week from a table column

[Gangula]

I have a table in which I have a column for dates. I want to count the number of values in it which are in the Next week. How to do that?

I tried using the below code, but it doesn't work.

let
 Source = List.Count(List.Select(Date_Column[Date], each Date.IsInNextWeek(Date_Column[Date])="TRUE")])
in
 Source

[v-yulgu-msft · Accepted solution]

Hi @Gangula,

Please try this:

= Table.AddColumn(#"Previous Step", "Count Dates", each Table.RowCount(Table.SelectRows(Source, each Date.IsInNextWeek([Dates])=true)))

Best regards,

Yuliana Gu

[Gangula]

Thanks a lot. This works, but would it be possible for the new column to get 1 if the adjacent date is in next week and 0 if not.