https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Referencing-multiple-columns-with-2-tables/m-p/3940478#M9671 <P>I have columns:</P><P>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.<BR /><BR /></P><P>Primary Estimated hours is associated with Assigned to Primary</P><P>Secondary Estimated hours is associated with Assigned to Secondary</P><P>Third Estimated hours is associated with Assigned to Third</P><P>Fourth Estimated hours is associated with Assigned to Fourth</P><P>Fifth Estimated hours is associated with Assigned to Fifth</P><P>Sixth Estimated hours is associated with Assigned to Sixth</P><P>Seventh Estimated hours is associated with Assigned to Seventh</P><P>&nbsp;</P><P>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</P><P>&nbsp;</P><P>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.&nbsp;<BR /><BR />Thank you very much for your time&nbsp;<BR /><BR /></P> Wed, 22 May 2024 17:12:55 GMT HappeNick_91 2024-05-22T17:12:55Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Referencing-multiple-columns-with-2-tables/m-p/3940478#M9671 <P>I have columns:</P><P>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.<BR /><BR /></P><P>Primary Estimated hours is associated with Assigned to Primary</P><P>Secondary Estimated hours is associated with Assigned to Secondary</P><P>Third Estimated hours is associated with Assigned to Third</P><P>Fourth Estimated hours is associated with Assigned to Fourth</P><P>Fifth Estimated hours is associated with Assigned to Fifth</P><P>Sixth Estimated hours is associated with Assigned to Sixth</P><P>Seventh Estimated hours is associated with Assigned to Seventh</P><P>&nbsp;</P><P>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</P><P>&nbsp;</P><P>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.&nbsp;<BR /><BR />Thank you very much for your time&nbsp;<BR /><BR /></P> Wed, 22 May 2024 17:12:55 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Referencing-multiple-columns-with-2-tables/m-p/3940478#M9671 HappeNick_91 2024-05-22T17:12:55Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Referencing-multiple-columns-with-2-tables/m-p/3969412#M9788 <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>, in a <STRONG>usable</STRONG> format (not as a screenshot).<BR /><BR />Do not include sensitive information or anything not related to the issue or question. <BR /><BR />If you are unsure how to upload data please refer to <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR /><BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Mon, 03 Jun 2024 17:26:45 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Referencing-multiple-columns-with-2-tables/m-p/3969412#M9788 lbendlin 2024-06-03T17:26:45Z