Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
moesteez
Helper I
Helper I

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'[Date]))
VAR month = MONTH(FIRSTDATE('Calendar 2'[Date]))
VAR day = DAY(FIRSTDATE('Calendar 2'[Date]))
 
Ive tested each of these variables and they are returning the correct year, month and day respectively. But when I use them in the next step:
 
CALCULATE([Quantity], 'Calendar'[Date] = DATE(year, month , day ) )
 
I get a blank value. If I swap out the variables for my own text the measure works fine. Am I doing something wrong here?
 
Thanks
 
4 REPLIES 4
moesteez
Helper I
Helper I

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

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

amitchandak
Super User
Super User

@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 ))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.