Show Max and min date whatever selected in Date Slicer

aqsasaleem — Tue, 16 Jan 2024 12:08:02 GMT

I have transactions on different dates i want to show Min and Max date whatever i selected in slicer. Currently my measures are showing whatever transaction min and max date.

Statement of Account "MinDate" From "MaxDate" should be 31/05/2012 and 13/02/2024

Measures which i'm currently using are

Selected Min date = CALCULATE ( FORMAT(MIN ( cl_resultset[md_date] ), "dd/mm/yyyy"), ALLSELECTED ( 'cl_resultset' ))

Selected Max date = CALCULATE ( FORMAT(Max ( cl_resultset[md_date] ), "dd/mm/yyyy"), ALLSELECTED ( 'cl_resultset' ))

Re: Show Max and min date whatever selected in Date Slicer

Dangar332 — Tue, 16 Jan 2024 13:35:46 GMT

hi, aqsasaleem

try below

Selected Min date = CALCULATE ( FORMAT( MIN (cl_resultset[md_date] ), "dd/mm/yyyy" ), ALL( cl_resultset[md_date]) ) Selected Max date = CALCULATE ( FORMAT( max (cl_resultset[md_date] ), "dd/mm/yyyy" ), ALL( cl_resultset[md_date]) )

topic Show Max and min date whatever selected in Date Slicer in DAX Commands and Tips

Show Max and min date whatever selected in Date Slicer

Re: Show Max and min date whatever selected in Date Slicer