Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Correcting erroneous data

Hello All,   I have a query I'm hoping you can help with. While building a report for a business stakeholder I was informed that roughly 5,000 lines of data in the SQL dataset have some erroneous d...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    1. You can import both sql data and excel data into power bi desktop

    2. In power query, use merge tables to merge these two tables based on [Contract number] column as a new table

    3. Remove unnecessary columns, you can retain the excel correct data column or retain both of the early date column to use replace values in power query as your need:

    = Table.ReplaceValue(#"Expanded Excel Data",each [Early Termination Date],each [Excel Data.Early Terminnation Date],Replacer.ReplaceValue,{"Early Termination Date"})

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

1. You can import both sql data and excel data into power bi desktop

2. In power query, use merge tables to merge these two tables based on [Contract number] column as a new table

3. Remove unnecessary columns, you can retain the excel correct data column or retain both of the early date column to use replace values in power query as your need:

= Table.ReplaceValue(#"Expanded Excel Data",each [Early Termination Date],each [Excel Data.Early Terminnation Date],Replacer.ReplaceValue,{"Early Termination Date"})

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.