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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

carnage66 , Last 6 month of data based on selected date

 

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

 

Based on today

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

 

you can switch based on isfiltered

 

But if you need trend based on selected date you need independent table

 

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Nikkkkkkkkk's avatar
Nikkkkkkkkk
New Member
2 years ago

Hi, 

 

Could you please tell is it posssible to show sum of last 6 months if in the table I chose only 1 year and month, to avoid of "based on selected date". 

 

Thanks!