Forum Discussion

fahmi_laswar's avatar
fahmi_laswar
Frequent Visitor
7 years ago
Solved

get last date from filter slicer

how to create measugre to Get the last date in filter slicer

  • Hi fahmi_laswar 

     

    Try this:

     

    Measure = MAX(CalendarTable[Date])

    where CalendarTable[Date] is the field you use in the slicer

3 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion

    Hi fahmi_laswar 

     

    Try this:

     

    Measure = MAX(CalendarTable[Date])

    where CalendarTable[Date] is the field you use in the slicer

    • fahmi_laswar's avatar
      fahmi_laswar
      Frequent Visitor
      thanks for your replay,but the result show the max date in table not the filterd date in slicer
      • AlB's avatar
        AlB
        Icon for Community Champion rankCommunity Champion

        Hi fahmi_laswar,

        Can you share the pbix and I'll have a look? If you have confidential data, share a file with dummy data that reproduces the issue.

        Cheers