Slow to get value most recent ignoring month of row date

[maycon_bb]

Hi all, 

I have two tables, I need to get the most recent value and cod_in in the table (IN) ignoring month of data row table (Out)

I'm currently using this measure:

VALUE_RECENT = VAR _date = EOMONTH(SELECTEDVALUE(OUT[DATE]),-1)
VAR _data = MAXX(FILTER('IN', 'IN'[DATE]<= _date),'IN'[DATE])
RETURN
 MAXX(FILTER('IN','IN'[DATE] = _data),'IN'[VALUE])

COD_IN_RECENT = VAR _date = EOMONTH(SELECTEDVALUE(OUT[DATE]),-1)
VAR _data = MAXX(FILTER('IN', 'IN'[DATE]<= _date),'IN'[DATE])
RETURN
 MAXX(FILTER('IN','IN'[DATE] = _data),'IN'[COD_IN])

 Result

Does someone know a good alternative for this measure?

File exemple: Example.pbix

[Anonymous]

Hi @maycon_bb 

I have a few questions about this post, please help provide more detail information for us to solve it effectively.

1. I can’t download the Example.pbix file that you linked. Please re-upload if necessary and keep data privacy confidential.
2. Did the two measures return the correct expected results? If so, you want to further optimize the performance of your measurements, do you?
3. Please explain more about “ignoring month of data row table (Out)”, it is better to provide an example to demonstrate it.
4. Why use many-to-many relationships? Normally we recommend using one-to-many relationships. You can refer to https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#cardinal....

Best Regards,

Jarvis Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.