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 wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.