Forum Discussion
Solved
Comparing Dates in Multiple Tables
Hi, I'm pretty new to Power BI and am completely stumped on this one. I have data in three different tables and I need to find the most recent Meter Reading Date (Table 2) or Overhaul date (Table 3)...
pls see if this is what you want .
create relationships between tables and create a measure
Measure = max(max('Overhauls'[Date of Last Reading]),max('Meter Readings'[Date of Last Reading ]))pls see the attachment below
pls see if this is what you want .
create relationships between tables and create a measure
Measure = max(max('Overhauls'[Date of Last Reading]),max('Meter Readings'[Date of Last Reading ]))
pls see the attachment below