Daniil
8 years agoKudo Kingpin
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...
RossChevalier
6 years agoHelper III
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
6 years agoKudo Kingpin
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] )
- RossChevalier6 years agoHelper III
Understood, thank you kindly for the rapid response and education