Forum Discussion

sekinod's avatar
sekinod
Helper II
5 years ago
Solved

Filter value by two dates columns

 

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

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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