Forum Discussion

carnage66's avatar
carnage66
Frequent Visitor
4 years ago
Solved

Filter last 6 months

I want to filter the last 6 months, so today in December, it should show Jul, Aug, Sep, Oct, Nov, Dec. However, if I use date filter "in the last 6 months", it starts from Jun and cuts days with the...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi carnage66 ,

     

    I have built a Calendar table by:

     

    Table = CALENDAR(DATE(2020,9,1),TODAY())

     

    Now please try to create a flag measure:

     

    Flag = IF(MAX('Table'[Date])> EOMONTH(MAXX(ALL('Table'),[Date]),-6),1,0)

     

    And apply it to filter pane:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi carnage66 ,

 

I have built a Calendar table by:

 

Table = CALENDAR(DATE(2020,9,1),TODAY())

 

Now please try to create a flag measure:

 

Flag = IF(MAX('Table'[Date])> EOMONTH(MAXX(ALL('Table'),[Date]),-6),1,0)

 

And apply it to filter pane:

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

bharteshm's avatar
bharteshm
Frequent Visitor
2 years ago

It working for table, but not on matrix if I have Date as Columns. Any solution