Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data Transformation Challenge

Hello Forum,   I'm trying to see if I can get help with a data transformation scenario.  I have a data table with 3 columns.  Employee, Date/Time and Weight.  Sometimes the inputs can go into the w...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,

     

    I remembered seeing this, and found it in M is for (Data) Monkey, a very useful book. KenPuls is one of the authors.

    So add a custom column with the formula below in the picture in PQ. You get the result in the picture.  You can then go to filter for that custom column and unfilter null.  That takes away the rows that have bad data.  You may want to copy those rows first, so that you could change your original data - you could sort by ascending, and the nulls float to the top.

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi Anonymous ,

I believe when you bring in the data to Power Query, it will signify an error if the type does not match the column type. Then you can either fix the data, or filter out errors in each  column. It is pretty cool. You may have to adjust the type first as in your date column. Also your emp id is probably better as text.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel