topic Re: How to find a value with multiple conditions in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-a-value-with-multiple-conditions/m-p/2902831#M94597 <P>Hey, yes this seems to work. Thank you!!</P> Mon, 14 Nov 2022 06:57:18 GMT adityah 2022-11-14T06:57:18Z How to find a value with multiple conditions https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-a-value-with-multiple-conditions/m-p/2902513#M94578 <P>I have a table which looks something like this</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Renewal_ID</TD><TD>Offer_id</TD><TD>General_excess</TD></TR><TR><TD>12677</TD><TD>1</TD><TD>30000</TD></TR><TR><TD>12677</TD><TD>2</TD><TD>10000</TD></TR><TR><TD>12677</TD><TD>0</TD><TD>20000</TD></TR><TR><TD>12712</TD><TD>7</TD><TD>30000</TD></TR><TR><TD>12712</TD><TD>8</TD><TD>10000</TD></TR><TR><TD>12712</TD><TD>0</TD><TD>20000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>This is just a snapshot and there are multiple renewal_id's and offer_id's. I am trying to add a new column which captures the general_excess for offer_id = 0 for each renewal_id column. it should look something like this:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Renewal_ID</TD><TD>Offer_id</TD><TD>General_excess</TD><TD>General_excess_o</TD></TR><TR><TD>12677</TD><TD>1</TD><TD>30000</TD><TD>20000</TD></TR><TR><TD>12677</TD><TD>2</TD><TD>10000</TD><TD>20000</TD></TR><TR><TD>12677</TD><TD>0</TD><TD>20000</TD><TD>20000</TD></TR><TR><TD>12712</TD><TD>7</TD><TD>30000</TD><TD>20000</TD></TR><TR><TD>12712</TD><TD>8</TD><TD>10000</TD><TD>20000</TD></TR><TR><TD>12712</TD><TD>0</TD><TD>20000</TD><TD>20000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I tried using lookupvalue but that results in multiple values being returned. Sorry if this question seems very trivial but I am just learning powerbi. Any help will be appreciated!</P><P>&nbsp;</P><P>Thanks</P> Mon, 14 Nov 2022 03:16:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-a-value-with-multiple-conditions/m-p/2902513#M94578 adityah 2022-11-14T03:16:58Z Re: How to find a value with multiple conditions https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-a-value-with-multiple-conditions/m-p/2902537#M94581 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="471237" data-lia-user-login="adityah" class="lia-mention lia-mention-user">adityah</a> , A new column </P> <P>maxx(filter(Table, [Renewal_ID] = earlier([Renewal_ID])&nbsp; &amp;&amp; [Offer_id] =0) , [General_excess])</P> Mon, 14 Nov 2022 03:33:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-a-value-with-multiple-conditions/m-p/2902537#M94581 amitchandak 2022-11-14T03:33:33Z Re: How to find a value with multiple conditions https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-a-value-with-multiple-conditions/m-p/2902831#M94597 <P>Hey, yes this seems to work. Thank you!!</P> Mon, 14 Nov 2022 06:57:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-find-a-value-with-multiple-conditions/m-p/2902831#M94597 adityah 2022-11-14T06:57:18Z