Forum Discussion

AbsoluteNovice's avatar
AbsoluteNovice
New Member
2 years ago
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)...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    AbsoluteNovice 

    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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Your solutions is so great ryan_mayu 

Hi, AbsoluteNovice 

Have you solved the current problem? If yes, you can share your solution here or mark the help that is useful to you as a solution so that other members of the community can quickly find the answer when they encounter similar problems. Thank you again.

 

 

Best Regards

Jianpeng Li