Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

comparing column row

so I've 2 different table both tables contains a column called invoice nr,( the tables contain more column such as date and so on) my goal is to create a measure (or something else that could do the...

Need Help

Zubair_Muhammad

8 years ago

Anonymous

Try this revision

Please see revised file as well

CalculatedTable =
VAR temp =
    CALCULATETABLE (
        EXCEPT (
            VALUES ( InvoiceLineTESTv4[Invoice Nr] ),
            VALUES ( ExtractTESTv4[Invoice Nr] )
        ),
        INTERSECT ( VALUES ( InvoiceLineTESTv4[Date] ), VALUES ( ExtractTESTv4[Date] ) )
    )
RETURN
    GENERATE (
        temp,
        CALCULATETABLE (
            SELECTCOLUMNS (
                InvoiceLineTESTv4,
                "Date", [Date],
                "Other Column1", [Other Column.1]
            )
        )
    )

comparing column row.pbix76 KB

Zubair_Muhammad

Community Champion

8 years ago

HI Anonymous

Could you copy paste few rows of from each Table with Expected Ouput

For some reason I am not able to access Drop Box

For example

Table1