Forum Discussion

Chandrashekar's avatar
Chandrashekar
Resolver 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 to use date from Calendar table only.

 

Link: Sample Data 

 

Regards,

Chandrashekar B

14 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    Hi, Chandrashekar

     

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

     

    Adjust your table name and column name

    • Chandrashekar's avatar
      Chandrashekar
      Resolver III
      2 years ago

      Hello,

       

      Should I do this changes in Calendata table. rite?

       

      Regards,

      Chandrashekar B

      • Dangar332's avatar
        Dangar332
        Resident Rockstar
        2 years ago

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

        You get your answer 

    • Chandrashekar's avatar
      Chandrashekar
      Resolver III
      2 years ago

      Hello,

       

      Could not able to find PBIX file in the link provided.

       

      Regards,

      Chandrashekar B

    • Chandrashekar's avatar
      Chandrashekar
      Resolver III
      2 years ago

      Thanks. It works is there any other way to get other than lookup.

       

      Regards,

      Chandrashekar B

      • Dangar332's avatar
        Dangar332
        Resident Rockstar
        2 years ago

        hi, Chandrashekar 

         

        it's possible but i did not get answer at this time.


        it's possible in measure but you want in column and at this time i not get solution beacuse i try serval  time without lookup but i get erroe then i use lookup function.

         

        here using measure 

         

         

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