Filter value by two dates columns

[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

[Anonymous · Accepted solution]

Hi @sekinod,

Current power bi slicers not able to be filter on multiple fields at the same time.

For you scenairo, you can use date field that not linked to current table and write a measure with if statement to compare selection and current values and use on visual level filter to filter records.
Regards,

Xiaoxin Sheng