Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Filtro MAT, YTD, QTR, MTH

Good morning, everyone:

Dear please I would like if you help in something, I need a table that between two dates can show me all the dates according to the filter I choose, it can be the mobile year, current month etc, for example if in the filter I choose the mth that I park all the dates of the final month, my choose the mat, I give me the last 12 months of the final month, and so on.

Thanks in advance to everyone for the help

jminanoc_0-1653917662225.png

1 Reply

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

    Syndicate_Admin , if you select a date and need more than that, you need an independent date table

     

    example 12 month

     

    //Date1 is independent Date table, Date is joined with Table
    new measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    var _min = eomonth(_max, -12) +1
    return
    calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

     

     

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