Forum Discussion
dyee4613
6 years agoHelper I
My Standards Table is Not Filtering Correctly
Goal: This report calculates the number of days worked per cost center (program). It multiples the number of days work by a standard depending on the item (apron, arm sleeve, etc). It takes that nu...
richbenmintz
6 years agoResident Rockstar
dyee4613 ,
I would suggest that you re build your standards table, so that it contains 2 columns: Item and standard_value. you could then join the standards to sheet2 and get the appropriate standard for each item.
As amitchandak suggested a copy of the pbix file and expected output would go a long way in helping the community solve your issue