Forum Discussion

Prima_'s avatar
Prima_
Resolver I
3 years ago
Solved

Avoid duplicates in date slicer

Hi,   How to have distinct values in the date slicer?     Thanks.      
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Prima_ , Create a new column; format will not do in this case 

     

    month Year = format([Date], "mmm YYYY")

  • Prima_'s avatar
    Prima_
    3 years ago

    Thanks Rico Zhou, but, that's not what I want.  I tried creating a new column as suggested by amitchandak, but, it worked only after changing the format as shown below. Thanke amitchandak.

     

     

     

amitchandak's avatar
amitchandak
Super User
3 years ago

Prima_ , Create a new column; format will not do in this case 

 

month Year = format([Date], "mmm YYYY")

Prima_'s avatar
Prima_
Resolver I
3 years ago

Thanks Rico Zhou, but, that's not what I want.  I tried creating a new column as suggested by amitchandak, but, it worked only after changing the format as shown below. Thanke amitchandak.