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.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , you can load that into power bi and get these get dates populated in table.

You can copy data from one table to another like

City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])