How to filter date range in graph by previous month(s) till current date

[NandhaKumarPBI]

Hi Team,

I am new here , and would love to get your help on this!

I am working on a dashboard where using a line graph, the date range on that needs to filtered for 6 months (Previous 6th month to 'Till Date') eg: 01 June 2020 to 05 Novemeber 2020 (Current Date).

I tried to use the relative filter but both the month Options did not do what i need.

Can you kindly help me out on this one!

Thanks in advance!

[amitchandak · Accepted solution]

@NandhaKumarPBI , Try a rolling measure like this with a date table

Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-6,MONTH))

Also, refer to this video: https://www.youtube.com/watch?v=duMSovyosXE

[v-jayw-msft · Accepted solution]

Hi @NandhaKumarPBI ,

Relative date slicer should work. Or you could create a measure as below and add it to visual filter.

Measure = IF(SELECTEDVALUE('Table'[date])>=EDATE(TODAY(),-6),1,0)

Best Regards,

Jay

[amitchandak · Accepted solution]

@NandhaKumarPBI , Try a rolling measure like this with a date table

Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-6,MONTH))

Also, refer to this video: https://www.youtube.com/watch?v=duMSovyosXE