Filter by two dates

[sekinod]

I want to filter the above data by two date columns which are "LPD" and "DATEOPEN". "DATEOPEN" columns values should be within the month and "LPD" should be month end date. According to that DMCBAL value. For example, If "DATEOPEN" filter is 1/8/2019 to 31/8/2019 "DMCBAL " should be as per 31/8/2019 "LPD" date.

Thank You

[amitchandak]

@sekinod , You can join them with common dat table and there will one active join , other you can activate using userelation

you can use CLOSINGBALANCEMONTH for month end balance along with userelation - https://www.youtube.com/watch?v=yPQ9UV37LOU

For userelation

https://www.youtube.com/watch?v=e6Y-l_JtCq4

[sekinod]

Dear @amitchandak 

I watched your videos but I couldn't get it. Could you please write a measure for this. That will be highly appreciated. Thank you.