Forum Discussion
Comparing Two Different Datasets for missing values
Hi, I have two different datasets/tables in Power BI. One that is a Power BI dataset and the other is a Google BigQuery direct query. Lets call them table_a and table_b. I would like to compa...
Hi Anonymous
You can create a new calculated tableMissing From b = EXCEPT ( VALUES ( Table_a[Column A] ), VALUES ( Table_b[Column A] ) )Or you can create a measure, for example for a card visual
Missing From b = CONCATENATEX ( EXCEPT ( VALUES ( Table_a[Column A] ), VALUES ( Table_b[Column A] ) ), [Column A], UNICHAR ( 10 ) )
Hi Anonymous
You can create a new calculated table
Missing From b =
EXCEPT ( VALUES ( Table_a[Column A] ), VALUES ( Table_b[Column A] ) )Or you can create a measure, for example for a card visual
Missing From b =
CONCATENATEX (
EXCEPT ( VALUES ( Table_a[Column A] ), VALUES ( Table_b[Column A] ) ),
[Column A],
UNICHAR ( 10 )
)I used the first suggestion of creating a new calculated table and that worked, thank you!
I tired your first calculated table suggestion and got the following error:
Error Message:
MdxScript(Model) (59, 38) Calculation error in measure 'CMDB_Active'[Missing from b]: A table of multiple values was supplied where a single value was expected.