Forum Discussion

PC2022's avatar
PC2022
Helper III
1 year ago
Solved

Identify tasks with current date

I need to write dax that will identify tasks that are taking place as of today (from the example below it should only be "JPA". If the task has been 100% complete, it shouldn't be included in the res...
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    Hi PC2022 ，

     

    try to write a measure like:

    Count = 
COUNTROWS(
    CALCULATETABLE(
        VALUES(data[Name]),
        FILTER(
            data,
            data[start]<=TODAY()
                &&data[finish]>=TODAY()
        )
    )
)

or 

List = 
CONCATENATEX(
    CALCULATETABLE(
        VALUES(data[Name]),
        FILTER(
            data,
            data[start]<=TODAY()
                &&data[finish]>=TODAY()
        )
    ),
    data[Name],
    ", "
)
PC2022's avatar
PC2022
Helper III
1 year ago

Thank you! My coworker helped me come up with the formula. I had to turn the project in before i heard back from here. I appreciate your help!

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PC2022 

     

    Glad to hear you solved the problem! Could you please mark the solution as an ANSWER? This will help more users who are facing the same or similar difficulties. Thank you!

     

    Best Regards,
    Yulia Xu