Forum Discussion
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 the latest modification of the Record, for that I have to check the latest createdon Comment related to that Record and the modifiedon of the Record itself and decide which one is the most recent.
I'm new to PowerBI and this might be simple, but I have no idea how to do it.
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
3 Replies
- AlB
Community Champion
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
Hi AlB thanks for the response.
I was actually missing the CALCULATE function.
- AlB
You need it to trigger context transition and have the filter propagate down the relationship
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
