cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
InterSimi Regular Visitor
Regular Visitor

DAX reference of a date in another table

Hi,

 

I need some help referencing a date in another table.

 

I currently have 2 tables (there are more, but not related to my query):

 

ForecastPushTable:

Case number column

Value column

Forecast column

 

MetricsDateTable:

Metrics date Column 

 

The ForecastPushTable has many rows, but the MetricsDateTable only has one cell, which is basically the date the report was pulled.

 

I wish to create another calculated column in the ForecastPushTable and if the 'Forecast Column' date is greater than 'Metrics date column' date to return the "Value", otherwise return 'zero'.

 

The issue I am having, is that I am unable to create a calculated column in the ForecastPushTable and reference the metrics date Column.

 

Any ideas how to overcome this?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: DAX reference of a date in another table

You should be able to use LOOKUPVALUE or MAX/MIN, like this:

 

Column = MAX('MetricsDateTable'[Metrics date Column])

Check-out my Back to School contest submission: Dinosaurs!

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

3 REPLIES 3
Super User
Super User

Re: DAX reference of a date in another table

You should be able to use LOOKUPVALUE or MAX/MIN, like this:

 

Column = MAX('MetricsDateTable'[Metrics date Column])

Check-out my Back to School contest submission: Dinosaurs!

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

InterSimi Regular Visitor
Regular Visitor

Re: DAX reference of a date in another table

Fantastic, the 'MAX' expression sorted me out. Thank you

Super User
Super User

Re: DAX reference of a date in another table

Awesome!


Check-out my Back to School contest submission: Dinosaurs!

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 252 members 2,713 guests
Please welcome our newest community members: