Power Bi Last 30 days filter

To filter your average calculation to only include requests submitted in the last 30 or 60 days, you can use a measure with a FILTER function to restrict the data used in the calculation. Here's an example measure that calculates the average number of days between submission and acceptance for requests submitted in the last 30 days:

This measure first uses the CALCULATETABLE function to filter the data in 'YourTable' to only include requests submitted in the last 30 days. It then uses the FILTER function to further restrict the data to only include requests that have an acceptance date (i.e. the request has been accepted). Finally, it calculates the average number of days between submission and acceptance for the filtered data using the AVERAGEX function.

You can adjust the number of days by changing the second and third arguments of the DATESBETWEEN function. For example, to filter requests submitted in the last 60 days, you would use TODAY()-60 instead.