https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-equivalent-of-referencing-a-cell-in-excel/m-p/2707706#M82163 <P>I need some help with finding the&nbsp;Power BI equivalent of referencing a cell in excel. I have a table of about 200K rows and 7 columns and I am trying to dynamically create a new boolean column by comparing an values in an exsisting column with a changeable value in an input box.&nbsp; For example, If I type 80% into the input box, I want to compare it with each value in column 7, and if greater than, return 1, or 0.....just like one would in excel by simply refernce the imput cell.</P><P>&nbsp;</P><P>Thanks!</P> Wed, 17 Aug 2022 18:53:51 GMT Anonymous 2022-08-17T18:53:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-equivalent-of-referencing-a-cell-in-excel/m-p/2707706#M82163 <P>I need some help with finding the&nbsp;Power BI equivalent of referencing a cell in excel. I have a table of about 200K rows and 7 columns and I am trying to dynamically create a new boolean column by comparing an values in an exsisting column with a changeable value in an input box.&nbsp; For example, If I type 80% into the input box, I want to compare it with each value in column 7, and if greater than, return 1, or 0.....just like one would in excel by simply refernce the imput cell.</P><P>&nbsp;</P><P>Thanks!</P> Wed, 17 Aug 2022 18:53:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-equivalent-of-referencing-a-cell-in-excel/m-p/2707706#M82163 Anonymous 2022-08-17T18:53:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-equivalent-of-referencing-a-cell-in-excel/m-p/2707730#M82164 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;<BR />This is how you do it in power bi (refer attached sample file)</P> <P><img /><img /><img /></P> Wed, 17 Aug 2022 19:11:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-equivalent-of-referencing-a-cell-in-excel/m-p/2707730#M82164 tamerj1 2022-08-17T19:11:05Z