Forum Discussion

Daysy's avatar
Daysy
Frequent Visitor
4 years ago
Solved

Dynamic Date Filter Help Please

Hi All,   Have been using PBI for a year or so and this site has been a great resource, but in this instance my Google-Fu is failing me.   I have an extensive table that shows each payment a cust...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Daysy ,

    Here are the steps you can follow：

    1. Create calendar.

    Date_Table =
CALENDARAUTO()

    2. Create calculated column

    date_end =
EOMONTH('Date_Table'[Date],0)

    3. Create measure.

    Flag =
var _select=SELECTEDVALUE('Date_Table'[date_end])
return
IF(
    MONTH(_select)=MONTH(MAX('Table'[Last Movement Date])),1,0)
Place [Flag] in Filters, set is=1, apply filter.

    4. Result:

     

    Best Regards,

    Liu Yang

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

smpa01's avatar
smpa01
Community Champion
4 years ago

Daysy  can you use a Calendar Table to do all the slicing, it would be way easier.

  • Daysy's avatar
    Daysy
    Frequent Visitor
    4 years ago

    Yes, I'm reasonably comfortable using calendar tables and could add one in to this.  It's the only way I could think to pick up the last days of the month and filter that way, but I'm not sure how to implement that.  

     

    Anonymous solution has got me part way there, thank you, using the latest movement date and latest movement number in the table and using the movement date in the slicer, but I would like to take it a step further and just have month end dates to slice by.

     

    Thanks

     

    Daysy