Forum Discussion
Fixed Date, Dynamic Year - Date Filtering Woes
Hello! It's me again with another date conundrum. What I want to do is filter a range of data based on its date. For example, I want to filter out anything from 1st April of the previous yea...
Anonymous - Try ditching your Date.From, I don't see why you need that. Also, you need () on your .LocalNow
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Date] >= Date.AddMonths(Date.StartOfYear(DateTime.LocalNow())),-9)
Exact error message: -
Expression.Error: The Date value must contain the Date component.
Details:
[Function]