value compare different column in same table

Question

i have table name&nbsp; called&nbsp; Master file.My data table looks like below.&nbsp; i want compare the values .if&nbsp;&nbsp;IN_table ,Out_Table ,Eo_In_table ,&nbsp;Eo_Out_table ,CMN&nbsp; &nbsp;all same its return TRUE .&nbsp;&nbsp;if Not matached&nbsp;N_table ,Out_Table ,Eo_In_table ,&nbsp;Eo_Out_table ,CMN&nbsp; &nbsp;its return False.&nbsp;ID&nbsp; &nbsp; Columnztype&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IN_table&nbsp; &nbsp; &nbsp; &nbsp; Out_Table&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Eo_In_table&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Eo_Out_table&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CMN&nbsp; &nbsp; &nbsp; &nbsp;11&nbsp; &nbsp; Adjustable_Shipment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 011&nbsp; &nbsp; Adjustable_Shipment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 011&nbsp; &nbsp; &nbsp;Fixed_Shipment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;326280&nbsp; &nbsp; &nbsp; &nbsp;326280&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;326280&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 326280&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 32628011&nbsp; &nbsp; &nbsp;Fixed_Shipment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1017720&nbsp; &nbsp; &nbsp; 1017720&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1017720&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1017720&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101772011&nbsp; &nbsp;&nbsp;Fixed_PLB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;36021816&nbsp; &nbsp; &nbsp; &nbsp;36021816&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;36021816&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36021816&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; 6502990611&nbsp; &nbsp; Fixed_PLB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;40041259&nbsp; &nbsp; &nbsp; &nbsp; 40041259&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40041259&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40041259&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;41468899 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Expected Output looks like&nbsp;ID&nbsp; &nbsp; Columnztype&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IN_table&nbsp; &nbsp; &nbsp; &nbsp; Out_Table&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Eo_In_table&nbsp; &nbsp; &nbsp; Eo_Out_table&nbsp; Year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CMN&nbsp; &nbsp; &nbsp; &nbsp; Status&nbsp;11&nbsp; &nbsp; Adjustable_Shipment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;True&nbsp;11&nbsp; &nbsp; Adjustable_Shipment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; True&nbsp;11&nbsp; &nbsp; &nbsp;Fixed_Shipment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;326280&nbsp; &nbsp; &nbsp; &nbsp;326280&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;326280&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;326280&nbsp; &nbsp; &nbsp; &nbsp; 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 326280&nbsp; &nbsp; &nbsp; True&nbsp; &nbsp;&nbsp;11&nbsp; &nbsp; &nbsp;Fixed_Shipment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1017720&nbsp; &nbsp; &nbsp; 1017720&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1017720&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1017720&nbsp; &nbsp; &nbsp; &nbsp;2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1017720&nbsp; &nbsp; &nbsp; &nbsp;True&nbsp;11&nbsp; &nbsp;&nbsp;Fixed_PLB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;36021816&nbsp; &nbsp; &nbsp; &nbsp;36021816&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;36021816&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;36021816&nbsp; &nbsp; &nbsp; &nbsp;2021&nbsp; &nbsp; &nbsp; &nbsp; 65029906&nbsp; &nbsp; &nbsp; False&nbsp;11&nbsp; &nbsp; Fixed_PLB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;40041259&nbsp; &nbsp; &nbsp; &nbsp; 40041259&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40041259&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40041259&nbsp; &nbsp; &nbsp; 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;41468899&nbsp; &nbsp; &nbsp;Fasle&nbsp;&nbsp;&nbsp;i have tired below measure getting Error :Check one = var _A=CALCULATE(MAX(Master [CMN ]),FILTER(Master ,Master [IN_Tables]= MAX(Master [Out_Tables]) &amp;&amp;Master [Eo_In_table]=MAX('Master '[ Eo_Out_table]) ))REturnif(MAX(Master [ICMN ]) =_A,TRUE(),False())&nbsp; &nbsp;&nbsp;&nbsp;what mistake i did?&nbsp; looking for support . thanks in advance.&nbsp;

valtterin · Accepted Answer

Hi,Here is a pretty straightforward way to do this (albeit not the most elegant):Test Match = var col1 = SELECTEDVALUE('Table (3)'[Column1]) var col2 = SELECTEDVALUE('Table (3)'[Column2]) var col3 = SELECTEDVALUE('Table (3)'[Column3]) var col4 = SELECTEDVALUE('Table (3)'[Column4]) returnIF(col1=col2&amp;&amp;col2=col3&amp;&amp;col3=col4,TRUE(),FALSE())&nbsp;Data:End result:I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!

Forum Discussion

value compare different column in same table

2 Replies

Related content

Compare two columns in different tables

Comparing Difference between two columns in two different tables

DAX or Query: Compare two columns in different Tables

Compare different tables

Compare two date columns from different tables