Forum Discussion
Measure Cross tables
Hey fellow power bi users, I currently have 2 tables, table A and table B, table A has a column with TRUE and FALSE values, in table B i want to create a measure that points towards table As c...
Shamatix,
Firstly, merge the two tables in Query Editor.
Secondly, expand the true/false column in the merged table.
Thirdly, create a calculated columns using DAX below.
Column = IF(Merge2[A.True/false]=TRUE(),"Approved","Failed")
Regards,
Lydia