Forum Discussion

froxas's avatar
froxas
Icon for Helper II rankHelper II
6 years ago
Solved

Dynamic filter on two variable

Hi, I have situation what I do not know how to solve, maybe somebody could bring me on a way.   I have a table with a contracts: contract number, version, start date and and date. User needs to g...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    froxas ,

     

    I would suggest you create a calculate column using dax below and then you can filter other columns based on that column.

    Status =
VAR report_date =
    SELECTEDVALUE ( Calendar[Date] )
RETURN
    IF (
        report_date >= start_date
            && report_date <= termination_date,
        "Active",
        "Inactive"
    )

    Community Support Team _ Jimmy Tao

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

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

froxas ,

 

I would suggest you create a calculate column using dax below and then you can filter other columns based on that column.

Status =
VAR report_date =
    SELECTEDVALUE ( Calendar[Date] )
RETURN
    IF (
        report_date >= start_date
            && report_date <= termination_date,
        "Active",
        "Inactive"
    )

Community Support Team _ Jimmy Tao

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