So I have a few Power BI fact tables that have all kinds of data in it. I don’t have access to the data source, just the .pbix file.
Some of the issues:
- monthly repeating employee data (empid, dob, gender, etc)
- data corrections resulting in one month’s value being different from another month (one month the grade is a 10, in another month that same record has the value as 7)
- yearly age differences
- judging from my calculation differences, there are more issues that still need to be revealed
The Power BI data model and some reports have already created (by someone else).
Is there any way I can detect these issues in advance so I can account for them in my DAX calculations?
I’ll assume the answer is no, but I would appreciate a few ideas on how to approach this scenario. I have taken into account the yearly repeating data, but the differences in some are of concern and I am not clear on how to deal with those.