Forum Discussion
Dacja
4 years agoFrequent Visitor
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...
- Anonymous4 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
Dacja
4 years agoFrequent Visitor