Show Max and min date whatever selected in Date Slicer

[aqsasaleem]

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' ))

[Dangar332 · Accepted solution]

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])
    )