Date range

This quick measure returns the selected date range formatted in accordance with the Wikipedia Manual of Style. The date format can be customized by changing the parameters listed below. N...

Other

Time Intelligence

RossChevalier

Helper III

6 years ago

Daniil I like the idea here, but my date column data type is Date/time not Date and I get an error saying that the Min function only accepts a column reference as an argument. I am very new to DAX. Any suggestions?

thanks

Ross

Daniil

Kudo Kingpin

6 years ago

RossChevalier: in this case, it doesn't matter if your Date column is of type Date/Time 🙂 Replace {Date} from my formula above with a fully qualified column reference, like so: 'Date'[Date]. So here's what part of the formula would look like:

-- Input dates
VAR MinDate         = MIN ( 'Date'[Date] )
VAR MaxDate         = MAX ( 'Date'[Date] )

RossChevalier
Helper III
6 years ago
Understood, thank you kindly for the rapid response and education