Forum Discussion

carlosfaganello's avatar
carlosfaganello
Regular Visitor
5 years ago
Solved

Get the most recent between several dates for a record

I have two tables: Records and Comments. Comments are related (*:1) to the Records. Comments have a createdon date and Records have a modifiedon date.   I want to create a column in Records with ...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi carlosfaganello 

    In a calc column, this should get you the latest relevant date from Comment

    Col =

    CALCULATE(MAX(Comments[CreatedOn])

     

    Then you can check with the modifiedOn from. I don't understand exactly what you need.

    In general, it very much helps if you show a sample of your tables and an example with the expected result based on that sample

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

     

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi carlosfaganello 

In a calc column, this should get you the latest relevant date from Comment

Col =

CALCULATE(MAX(Comments[CreatedOn])

 

Then you can check with the modifiedOn from. I don't understand exactly what you need.

In general, it very much helps if you show a sample of your tables and an example with the expected result based on that sample

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

 

 

carlosfaganello's avatar
carlosfaganello
Regular Visitor
5 years ago

Hi AlB thanks for the response.

I was actually missing the CALCULATE function.