Forum Discussion
Tables with Two Key
Hello, I Have two tables the first includes the Revenue Details and the other one claims, the tables looks something similar to the below, Medical Record No Visit Number Visit Date Name...
are you sure your PHA_CLAIM_ID and CLAIM_ID are clean and have no any spaces and other invisible symbols?
also, please, povide as your data looks like in original data sources, separately (ERAClaim and ACR)
do you create FOrmula as measure or calculated column?
do not hesitate to give a kudo to useful posts and mark solutions as solution
Yes Im sure the data is clean, i duplicated the table to check the details thats why it is appearing in two columns, i created a measure not a column
thats the result on your first data sample
let me see please on your original data sample
do not hesitate to give a kudo to useful posts and mark solutions as solution