cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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])

I have book! Learn Power BI from Packt


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

I have book! Learn Power BI from Packt


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!


I have book! Learn Power BI from Packt


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.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 111 members 1,709 guests
Please welcome our newest community members: