Forum Discussion
Data Validation using PowerBI
Hello all, I am trying to validate data in two tables. Below is an example of my table structure: New Table Date Project Fees Cost 6/1/2022 A 10 5 6/1/2022 B 12 ...
Hi WBAnalyst
create a 2way many to many relationship between both date columns. Place any of the date columns in a table visual along with the following measures
Fees Compare = SUM(OldTable[Fees])-SUM(NewTable[Fees])
Cost Compare = SUM(OldTable[Cost])-SUM(NewTable[Cost])
