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
moesteez's avatar
moesteez
Icon for Helper I rankHelper I
5 years ago

When i call the _min variable I get the correct date. So that part is working fine.

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi,  moesteez 

I suspect that the problem lies mainly in your [quantity].

You can consider directly replacing [quantity] with the complete formula.

 

Best Regards,
Community Support Team _ Eason