Dax command\if help

[2avrham]

Hi,

Im using the next code:
=if(And([BB] = [MTDate],[AA] = [TesterName]),[MASTER_STATUS],"")

that mean that if BB data is equal to MTdate data then check AA data equal to tester name, if all true take status data, if not paste "".

What i would like to know if there is a possibility to extend my search for more rows (different once) that applied to the =if And([BB] = [MTDate] but located At diffrent place.

 

[Matt Allington]

He a read of these two blog articles.

Best Practices for Power Pivot, Power Query and Power BI - Excelerator BI
i have no idea if your formula is referring to measures (using best practice syntax) or columns (not using best practice) . Also it is not clear if this formula is a calc column formula or a measure

How and Where to Get Help for Power BI - Excelerator BI
you need to share your data model and make it clearer what is going on.