Forum Discussion
Conditional Column - PowerQuery - Detect if date is in the last 7 or 30 days
Hello,
I have a table that contains a date column ( [time_recorded]).
I'm currently trying to create a conditional column that will display the following values ("Past week", "Past Month", "Other").
I've tried the following formula:
= Table.AddColumn(#"Expanded bi sites", "period", each if Date.IsInPreviousNDays([time_record], 7) = true then "Past 7 Days" else if Date.IsInPreviousNDays([time_record], 30) = true then "Past 30 Days" else "Other Period")
Please can someone advise?
4 Replies
- amitchandak
Super User
DavidGorgan , check if this can help
Table.AddColumn(#"Expanded bi sites", "period", each if Date.Date.IsInPreviousWeek([time_record]) = true then "Past week" else if Date.Date.IsInPreviousMonth([time_record]) = true then "Past Month" else "Other")Hello amitchandak,
Thank you for getting back to me.
I've tried the formula and I get the following error:
"Expression.Error: The name 'Date.Date.IsInPreviousWeek' wasn't recognized. Make sure it's spelled correctly."- amitchandak
DavidGorgan , My mistake, try like
Table.AddColumn(#"Expanded bi sites", "period", each if Date.IsInPreviousWeek([time_record]) = true then "Past week" else if Date.IsInPreviousMonth([time_record]) = true then "Past Month" else "Other")
