Last N days

[Maisouiii]

Hello,

I have a calendar table that contains a "date" column and a "Working day" column. I want to create a column "Last7Days" which takes the last 7 working days based on Today().

thanks in advance.

[v-yifanw-msft]

Hi @Maisouiii ,

May I ask if your problem has been solved. If @lbendlin 's reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.

Best Regards,

Ada Wang

[Maisouiii]

It can be a mesure, not only a column.

[lbendlin · Accepted solution]

If your calendar table is in import mode and is refreshed daily then you can add a flag to each date to indicate if it falls into that 7 working days range or not. Then you can use that flag as a filter on the page or the report.

Measures can only filter individual visuals.

[Maisouiii]

I want to use that column to filter all my page on last 7 days to get data of the last 7 days

[lbendlin]

a column can only contain a single value.  What are you planning to do with that column?