Forum Discussion
Error while comparing data from 2 tables
Hello GilbertQ & v-chuncz-msft,
Apologize for the delayed response, I was trying out your suggestions -
GilbertQ your suggestion to append the two tables and then compare the data worked.
I tried the other suggestions but they didn't work -
1. Change the cross filter direction on the relationships - FY17 Budget Data and FY18 Budget Data from BOTH to SINGLE?
2. Try to drag "Area" field from table Sites.
p.s. i also noticed the "Site" column of FY17 table had few extra entries that wasn't in "Site" column of FY18 table; corrceted this but the issue still persisted.
I used the "Combine" options from the PowerBI Desktop App (Query Editor) to append the two tables.
Once i combined the 2 tables and created 1 table there was no relationship to manage so everything became easy.
Thank you both for your suggestions.
/rgds
Hello GilbertQ & v-chuncz-msft,
Apologize for the delayed response, I was trying out your suggestions -
GilbertQ your suggestion to append the two tables and then compare the data worked.
I tried the other suggestions but they didn't work -
1. Change the cross filter direction on the relationships - FY17 Budget Data and FY18 Budget Data from BOTH to SINGLE?
2. Try to drag "Area" field from table Sites.
p.s. i also noticed the "Site" column of FY17 table had few extra entries that wasn't in "Site" column of FY18 table; corrceted this but the issue still persisted.
I used the "Combine" options from the PowerBI Desktop App (Query Editor) to append the two tables.
Once i combined the 2 tables and created 1 table there was no relationship to manage so everything became easy.
Thank you both for your suggestions.
/rgds