Default and filtered values by date

[Anonymous]

Hi all, I need to filter my Table (visual level) as follows:

When nothing is selected in date slicer table displays data for  last 30 days (excluding today) and whenever anytihng is selected in slicer it would filter accordingly to slicer selection.

Can you advice how to implement this logic and apply it on my table ?

[v-zhenbw-msft]

Hello @aleksandra_stan ,

It cannot be achieved without a measure, so we can create a date table and a measure to meet your needs.

1. Create a date table that has no relationship between the original table. Create the slicer with this table.

Date table = CALENDAR("2020/1/1","2020/12/31")

2. Then we can create a measure.

Measure = 
var _today = TODAY()
var _last30day = _today - 30
return
IF(
    HASONEFILTER('Date table'[Date]),
    CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Date]=SELECTEDVALUE('Date table'[Date]))),
    CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Date]>_last30day && 'Table'[Date]<=_today)))

If you don't meet your requirements, could you show the exact expected result based on the table we shared?

Best regards

Community support team _ zhenbw

If this post helps,then consider Accepting it as the solution to help other members find it faster.

BTW, pbix as an attachment.

[amitchandak]

@Anonymous , Try like

measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = maxx(allselected(Date),Date[Date])-30
return
if(isfilter(Date[Date]), [Measure], calculate([Measure],filter(Date, Date[Date] >=_min && Date[Date] <=_max)))

[Anonymous]

Thank you, @amitchandak ,

but I do not have any measures. I am displaying the entire table/columns as it is . Is there a way to filter it without measure or I still should create measures for the columns I am displaying as values ?