Forum Discussion

moesteez's avatar
moesteez
Icon for Helper I rankHelper I
5 years ago

Variables in the date function

Hi all,   Im trying to pass a date into a calculated dax measure but for some reason Im getting a blank value everytime.   This is what I have so far:   VAR year = YEAR(FIRSTDATE('Calendar 2'[...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

moesteez , Can you try the min date?

 

 

Measure =
VAR _min = Minx(allselected('Calendar 2'), 'Calendar 2'[Date]))
return
CALCULATE([Quantity], filter('Calendar', 'Calendar'[Date] = _min ))

  • moesteez's avatar
    moesteez
    Icon for Helper I rankHelper I
    5 years ago

    Thanks amitchandak , but this also returns a blank value for me. Im not sure why because in theory this should work