Forum Discussion
sekinod
Helper II
Helper IIFilter by two dates
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
2 Replies
- amitchandak
Super User
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
sekinodDear 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.
