topic Re: Slicer : Date Issue in DAX Commands and Tips

Slicer : Date Issue

Chandrashekar — Tue, 17 Oct 2023 09:49:05 GMT

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

Re: Slicer : Date Issue

Dangar332 — Tue, 17 Oct 2023 10:47:07 GMT

Hi, Chandrashekar

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

Adjust your table name and column name

Re: Slicer : Date Issue

Chandrashekar — Tue, 17 Oct 2023 11:19:00 GMT

Hello,

Should I do this changes in Calendata table. rite?

Regards,

Chandrashekar B

Re: Slicer : Date Issue

Dangar332 — Tue, 17 Oct 2023 11:34:48 GMT

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

You get your answer

Re: Slicer : Date Issue

Chandrashekar — Tue, 17 Oct 2023 11:49:06 GMT

Hello,

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

Link: Sample Data

Regards,

Chandrashekar B

Re: Slicer : Date Issue

Dangar332 — Tue, 17 Oct 2023 11:53:39 GMT

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

You can make separate table and connect it with calendar table

Re: Slicer : Date Issue

Chandrashekar — Tue, 17 Oct 2023 11:56:46 GMT

Hello,

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

Regards,

Chandrashekar B

Re: Slicer : Date Issue

Dangar332 — Tue, 17 Oct 2023 17:49:17 GMT

Hi, Chandrashekar

check below .pbix file . it might help

Refer HERE

Re: Slicer : Date Issue

Chandrashekar — Wed, 18 Oct 2023 04:54:55 GMT

Hello,

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

Regards,

Chandrashekar B

Re: Slicer : Date Issue

Dangar332 — Wed, 18 Oct 2023 05:06:25 GMT

it not open or something else?

click Here

Re: Slicer : Date Issue

Chandrashekar — Wed, 18 Oct 2023 05:07:18 GMT

Hello,

May be file missing in the folder.

Regards,

Chandrashekar B

Re: Slicer : Date Issue

Dangar332 — Wed, 18 Oct 2023 05:10:14 GMT

hi, Chandrashekar

dowanload file it automatically open in power bi desktop

i indicate green circle in image

Re: Slicer : Date Issue

Chandrashekar — Wed, 18 Oct 2023 05:15:57 GMT

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

Regards,

Chandrashekar B

Re: Slicer : Date Issue

Dangar332 — Wed, 18 Oct 2023 05:36:07 GMT

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.

Re: Slicer : Date Issue

Chandrashekar — Wed, 18 Oct 2023 06:40:31 GMT

Ok. Thank you

Regards,

Chandrashekar B