Forum Discussion
Power BI Table Filter >= Last week
Thank you Daryl.
I've just stared using Power BI.
So, sorry if I sound a bit clueless.
If I am correct, Step 1 filter by last week.
Step 2, paste the code and then change "Change Type" to "Filtered Row" as the step would apply a filter.
No worries LilMango82 - you need to learn to understand the structure of the M formulas. #"Change Type" is a reference to the previous applied step. If this was the second step the first is normally called "Source". If your previous step is called #"Filtered Row", then yes.
Note the structure of the formula:
Table.SelectRows is the function name for filtering (i.e. you are selecting rows)
#"Change Type" is the table to be filter or rows selected from.
each - this reflects that the following formula is applied to each row in the #"Change Type" table
[Dates] this was the name of the column that formula was applied to in the #"Change Type" table.
Date.IsInPreviousWeek is another formula to return True or False for the each row in the Table.