Forum Discussion

Proquation's avatar
Proquation
Frequent Visitor
3 years ago

Date Slicer Format / Date Retrieval

Hi there,

 

I have a date slicer setup. It is in the form dd/mm/yyyy.

I also want to display the start and end date into a Title. So I have created a measure with the following DAX:
StartDate = CALCULATE ( MIN ( [date] ), ALLSELECTED ( [date] )
EndDate = CALCULATE ( MAX ( [date] ), ALLSELECTED ( [date] )

The EndDate displays as m/dd/yyyy instead of dd/mm/yyyy
The StartDate displays as a RANDOM date that is fixed and does not change (in my case: 5/1/2023)

How can I fix my StartDate? Is there a way to show the value as a measure? Is there a way to format the date slicer to be mm/dd/yyyy to be in sync with the Title?

Thanks

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

     

     

    StartDate = CALCULATE ( MIN ( [date] ), ALLSELECTED ( [date] )

     

     

    looks like you are mixing the concepts of a measure, a column and (potentially) a table.

     

    Measures require table references when pointing to columns.