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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Refer if this blogpost can help

HR-Analytics-Active-Employee-Hire-and-Termination-trend

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin