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...
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

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

      No if you want to use in slicer than it not work.

      You can make separate table and connect it with calendar table 

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

        Hello,

         

        I have done it but still am getting all the dates which is not there in Sheet1 Table.

         

        Regards,

        Chandrashekar B