Filter records for certain range

[Anonymous]

Hi,

I have  data for which I want to apply  a DAX filter of last four month , where my current date is as below.

Current day=today-45 days, kindly help me with the logic for this

Regards,

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Do you want to show data from last four months(Current day-four months) to Current day(today-45 days)?

If so, create the following columns in your table. Then use the Date Range column in slicer to filter your visuals.

Current Day = TODAY()-45

Date Range = IF('Table'[DateKey]<='Table'[Current Day]&&'Table'[DateKey]>= 'Table'[Current Day]-120,1,0)

However, if you want to calculate last four months using today-4 months, then create Date Range column using the DAX below.

Date Range = IF('Table'[DateKey]<='Table'[Current Day]&&'Table'[DateKey]>=TODAY()-120,1,0)

Regards,

[ibarrau]

Hi, did you try relative date slicer of the preview features? I think this post can help you because it have different approaches

http://community.powerbi.com/t5/Desktop/Filter-to-select-last-month-and-the-weeks-of-the-last-month/...

Regards,