Last 30 days, according to date selection.

[gabrielvigo]

Hello everyone.

I need make the line chart with the last 30 days, acording to date selection.

My calendar is linked to my sales table.

Depending on the filter date selection, I need a line chart with the last 30 days.

EJ: DateSales <= "DateSelection" && DateSales >= "DateSelection - 30".

It's not the last 30 days from today. It's from the date selected in the filter.

[v-lili6-msft]

hi, @gabrielvigo

After my test, you may try to this way as below:

Add a last 30 day column for date table

last 30 date = DATEADD('Date'[Date],-30,DAY )

then use this column for the line chart  and basic date column for slicer

for example:

when I select date from 2018-03-09 to 2018-03-23 it returns from 2018-02-07 to 2018-02-21

Best Regards,

Lin

[manishsalanke]

In this can we achive if we select only one date for example if we select 2018 -03-09 it should only show last 30 days data from the date selected