Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
2 years ago

Slicer : Date Issue

Hello,   I am having 2 tables(Calendar & Sheet1). When I use date from calendar I am getting all the dates which is not available in Sheet1.   How to get dates only available in Sheet1 and I need...
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, Chandrashekar

 

Calculate (max('calender'[datecolumn]),keepfilters ('sheet'[datecolumn]))

 

Adjust your table name and column name

  • Chandrashekar's avatar
    Chandrashekar
    Icon for Resolver III rankResolver III
    2 years ago

    Hello,

     

    Should I do this changes in Calendata table. rite?

     

    Regards,

    Chandrashekar B

    • Dangar332's avatar
      Dangar332
      Icon for Resident Rockstar rankResident Rockstar
      2 years ago

      Make a new measure in calendar table and use that measure.

      You get your answer 

      • Chandrashekar's avatar
        Chandrashekar
        Icon for Resolver III rankResolver III
        2 years ago

        Hello,

         

        I tried but cannot able to drag measure into slicer. Can you show it in sample file.

        Link: Sample Data 

         

        Regards,

        Chandrashekar B