topic Link between rows in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Link-between-rows/m-p/932925#M9614 <P><SPAN>Hi all,</SPAN></P><P><BR /><SPAN>I have trouble to find a solution to build a report because the answer of the first question of the job will depend on how many set of questions will then appear :</SPAN><BR /><SPAN>In my Useranswer table, I am currently not able to link which price goes with which category, origin, ...</SPAN><BR /><SPAN>AnswerText in red should refer to the price in the red circle.</SPAN><BR /><SPAN>AnswerText in green&nbsp;should refer to the price in the green circle.</SPAN></P><P><SPAN>(to calculate the average price for the category 300-400g for exemple)&nbsp;&nbsp;</SPAN></P><P><SPAN>Currently, I am not able to determine that.</SPAN><BR /><SPAN>Any idea ? Thanks!</SPAN></P><P>&nbsp;</P><P><SPAN><img /></SPAN></P><P>&nbsp;</P> Fri, 14 Feb 2020 09:13:10 GMT Anonymous 2020-02-14T09:13:10Z Link between rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Link-between-rows/m-p/932925#M9614 <P><SPAN>Hi all,</SPAN></P><P><BR /><SPAN>I have trouble to find a solution to build a report because the answer of the first question of the job will depend on how many set of questions will then appear :</SPAN><BR /><SPAN>In my Useranswer table, I am currently not able to link which price goes with which category, origin, ...</SPAN><BR /><SPAN>AnswerText in red should refer to the price in the red circle.</SPAN><BR /><SPAN>AnswerText in green&nbsp;should refer to the price in the green circle.</SPAN></P><P><SPAN>(to calculate the average price for the category 300-400g for exemple)&nbsp;&nbsp;</SPAN></P><P><SPAN>Currently, I am not able to determine that.</SPAN><BR /><SPAN>Any idea ? Thanks!</SPAN></P><P>&nbsp;</P><P><SPAN><img /></SPAN></P><P>&nbsp;</P> Fri, 14 Feb 2020 09:13:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Link-between-rows/m-p/932925#M9614 Anonymous 2020-02-14T09:13:10Z Re: Link between rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Link-between-rows/m-p/934576#M9697 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>from your data example its almost unbelievable to understand your logic</P> <P>what answernumeric should be used for "Hors promo" and "Non" answers?</P> <P>&nbsp;</P> Sun, 16 Feb 2020 19:15:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Link-between-rows/m-p/934576#M9697 az38 2020-02-16T19:15:28Z