Slicer : Date Issue

[Chandrashekar]

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

[Dangar332]

Hi, @Chandrashekar 

check below .pbix file . it might help

Refer HERE  

[Chandrashekar]

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

Regards,

Chandrashekar B

[Dangar332]

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.

[Chandrashekar]

Ok. Thank you

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

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

Regards,

Chandrashekar B

[Dangar332]

it not open or something else?

click Here 

[Chandrashekar]

Hello,

May be file missing in the folder.

Regards,

Chandrashekar B

[Dangar332]

hi, @Chandrashekar 

dowanload file it automatically open in power bi desktop

i indicate green circle in image

[Dangar332]

Hi, @Chandrashekar

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

Adjust your table name and column name

[Chandrashekar]

Hello,

Should I do this changes in Calendata table. rite?

Regards,

Chandrashekar B

[Dangar332]

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

You get your answer 

[Chandrashekar]

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]

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

You can make separate table and connect it with calendar table 

[Chandrashekar]

Hello,

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

Regards,

Chandrashekar B