Referencing multiple columns with 2 tables
I have columns: ID, Assigned to Primary, Assigned to Secondary, Assigned to Third, Assigned to Fourth, Assigned to Fifth, Assigned to Sixth, Assigned to Seventh. Primary Estimated Hours, Secondary Estimated hours, Third Estimated hours, Fourth Estimated Hours, Fifth Estimated Hours, Sixth Estimated Hours, and Seventh Estimated hours. Primary Estimated hours is associated with Assigned to Primary Secondary Estimated hours is associated with Assigned to Secondary Third Estimated hours is associated with Assigned to Third Fourth Estimated hours is associated with Assigned to Fourth Fifth Estimated hours is associated with Assigned to Fifth Sixth Estimated hours is associated with Assigned to Sixth Seventh Estimated hours is associated with Assigned to Seventh Each Assigned to position has a different employee assigned to with different estimated hours. Each Record (ID) can have up to 7 assignees with different names and estimated hours How could I write a statement that looks at each record and calls out the record, the position, Employee name, and which estimated hours field is 0? Essentially I would like to look at folks who are assigned to a record but have not input any estimated hours. Thank you very much for your time
Textual Search
I'm trying to do a simple thing, but it seems to be extremely complicated. I have a table and I would like to filter items based on a column containing text. I need a textual filter: to display all items that contain a specific word to display either one word or another (or) to exclude words that I specify. I need these combinations of filters to perform precise searches, considering that there are longer textual descriptions. I need to incorporate this into a report so that I can manually enter words into each of the mentioned filters as needed. Thank you in advance!
How do I group columns by category in the same pivot table in excel?
Good afternoon guys, what's up? I need some help I'd like to layout the PowerBi "Matrix" in the same way that the "Pivot Table" groups the categories before showing the value, as shown in the photos below. 1. Excel - Pivot Table In the image below we can see that the pivot table first categorizes the values - Volume/Weight and Volume Measure - before grouping by BAT/PMI and JTI 2 - Power BI - Matrix In Power BI, the "Matrix" does just the opposite, first it categorizes BAT/PMI/JTI and then it categorizes the values I would like to know if it is possible to visualize the "Pivot Table" (example of photo 1) in PowerBI with "Matrix"?
