Forum Discussion
Jug
3 years agoFrequent Visitor
Select rows with the most recent date without groupby
Hi, I would like to know if someone could help me with the following question: I need to filter only the columns with the most recent date (and smaller than today, if possible), filtering the max...
amitchandak
Super User
3 years agoJug , refer my blog for the same
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
Jug
3 years agoFrequent Visitor
I was able to use this filter of the most recent date only in the dashboard, but I need to have information from different data tables in the same table.
For example, showing the most recent address from the address table and the customer name from the client table, they have already been related by the client code, but I need the filter so that the table does not bring all the registered addresses of the same client.
I would need to bring information from two tables and your formula includes only one. Would it be possible to include fields from another table?