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],
    ", "
)
FreemanZ's avatar
FreemanZ
Super User
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],
    ", "
)