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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
matsahiro
Helper II
Helper II

DAX not pulling up field in new measure

Hello, I'm fairly new to DAX. I'm trying to create this new measure comparing previous and old dates. DAX editor isn't pulling up the fields needed to compute though. 

 

New_date_indicator = IF(Table1[Date1]=Table2[Date2], "0", "1")

 

Any explanation to why intellisense isn't pulling up these fields to calculate? Thank you. 

 

This is what I'd like to create

 

Dummy data

Date1Date2ShopNew_date_indicator
2/1/20192/1/2019TX0
3/4/20186/7/2020FL1
4/5/20204/5/2020CA0
3/2/20213/2/2021WA1
2 REPLIES 2
MattAllington
Community Champion
Community Champion

There is a lot to learn. Table1[Date1] (and 2) are columns. Because they are columns, they can have multiple values in those columns. It's like me saying "is this column of 10 values greater than this other column of 10 values". You can't do this, and hence Intellisense won't offer it as an option. To do the calculation, you must find a single value in the first column and compare it to a single value in the second column, like this. 

New_date_indicator = IF(SELECTEDVALUE(Table1[Date1])=SELECTEDVALUE(Table2[Date2]), "0", "1")



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

@MattAllington Great! Thank you so much for your help. I believe that should work for me. The error that I recieve though is "there's not enough memory to complete this operation", when this should only calculate for about 12 rows. The selectedvalues on their own calculate just fine, it only throws an error when it is all pieced together in the IF statement. Any thoughts?

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (27)