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

Hey, sorry for the late reply , there is simple way to get the last 6 months data with or without current month ,and we don't need to write any DAX measure for this. we can do the changes in the PBI Desktop only. 

 

first select the table then go on page level filter -->drag your calendar column --> refer below

 

by choosing months it will dispaly until current month

by choosing calender month it will display the completed months

like this you can choose for years also

 

if it helped please save the solution and ACCEPT IT AS SOLUTION please