Forum Discussion
Solved
How can I solve this data quality issue?
I have a report like below where I'm showing some marketing data. My Fact_Table is connected to my Marketing_Channel_Mapping Table on Marketing_Channel_ID. My end previously has this report in Exc...
Hi ERing ,
You can fix this by adding a ID for the null values . This ID should also be part of the Dimension Mapping table.
The Below are the steps
1. Replaces the null values in Fact tables with an ID. In this case, I am replacing with 999
2. Add the new Id to the Dimension table.
Rest all no changes. The Output should look like shown below
Attaching the PBIX here for your reference.
Regards,
Hi ERing
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.