Show me data 3 month in the past and 6 month in the future

[Pfandgiraffe]

Hello togehter,

i want to show some datas (sales) within the last 3 month and the planed sales for the next 6 month.

My problem is to filter both in the same visual. The visual filter give me the possibility to filter a relative date include today. But i have to choose "in the last" OR "in the next" days, weeks, month, whatever.

Actually i realize the filter in the power query editor. There i can filter the date like i need. But there is missing TODAY.

= Table.SelectRows(#"Gefilterte Zeilen1", each Date.IsInPreviousNDays([Zugesagtes Lieferdatum], 90) or Date.IsInNextNDays([Zugesagtes Lieferdatum], 180))

p.s.: PowerQuerry editor has also the limitation for me, i can't choose "month" cause this will filter from the beginning of the last 3 month and not 3 month from today.

Any suggestions? Thanks in advance!

Norman

[pankajnamekar25 · Accepted solution]

Hello @Pfandgiraffe 

Create column using DAX and add this column to visual filter =1

ShowInVisual =

VAR TodayDate = TODAY()

RETURN

IF (

    'Date'[Date] >= EDATE(TodayDate, -3) &&

    'Date'[Date] <= EDATE(TodayDate, 6),

    1,

    0

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.