Forum Discussion
Basic variance between two columns.
Hi Power BI Experts, Loaded up two data sets, both identical in fields with exception of one columns values. Same as how you would do in excel, I would like to do a column with a variance val...
Hi Qinyun,
thank you for your explanation and i understand the rationale however when i try to create a relationship between the data, i receive an error message "Missing intermediate data between the two columns"? Yet i can't understand why this would be, both tables have different values in them?
Thanks,
Ross
You have to check the columns that are you trying to related. Maybe someone is different (Data, Format or another thing) to other.