I want to compair a transformed data to another data total and if it matches I want to show a green light 🚦
I have some reports created manually and want to validate it's correctness by checking with other raw data. In power bi dashboard can we compare a total row in a data with other data and show the validation results
Please read about INTERSECT().
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
User | Count |
---|---|
141 | |
60 | |
58 | |
58 | |
47 |
User | Count |
---|---|
135 | |
73 | |
58 | |
56 | |
51 |