Forum Discussion
Help: Who has time at a specific Date?
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
Hi Dacja ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a measure as below:
Available resources =
VAR _seldate =
SELECTEDVALUE ( 'Date'[Date] )
VAR _wresources =
CALCULATETABLE (
VALUES ( 'Forecast Entry'[Resource No.] ),
FILTER ( 'Forecast Entry', 'Forecast Entry'[Date] = _seldate )
)
RETURN
CONCATENATEX (
FILTER ( 'Resource', NOT ( 'Resource'[Resource No.] IN _wresources ) ),
'Resource'[Resource Name],
","
)
If the above one can't help you get the desired result, please provide more sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hey Anonymous ,
thank you very much for your solution, it works and is basically what i was looking for, except that i need a new table with a new row for every entry found:
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
Works like a charm, THANKS!
