Forum Discussion

Dacja's avatar
Dacja
Frequent Visitor
4 years ago
Solved

Help: Who has time at a specific Date?

Hello community,   I have a "Date" Table created with CALENDAR function I have a "Forecast Entry" query, which tracks which Person is planned for which Date. (fields: "Resource No.", Date) I have...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Dacja ,

    I updated my sample pbix file(see attachment), please check if that is what you want.

    1. Create a measure as below to judge if the resource is available

    Flag = 
    VAR _seldate =
        SELECTEDVALUE ( 'Date'[Date] )
    VAR _selresource =
        SELECTEDVALUE ( 'Resource'[Resource No.] )
    VAR _wresources =
        CALCULATETABLE (
            VALUES ( 'Forecast Entry'[Resource No.] ),
            FILTER ( 'Forecast Entry', 'Forecast Entry'[Date] = _seldate )
        )
    RETURN
        IF ( NOT ( _selresource IN _wresources ), 1, 0 )

    2. Create a table visual and apply a visual-level filter with the condition(Flag is 1)

    3. Hide the field Flag of the visual by toggle off the option "Text wrap" and adjust the size of the field

    Best Regards