Forum Discussion
Data Disappear
I have a column with 999+ rows when I select "remove duplicates" it remove all duplicates and others that are not duplicates.
=/
If you select 1 column and remove duplicates, it will also remove rows that have different values in other columns.
If non-duplicates are removed from the selected column, then please share your query and some fake data of which non-duplicates are removed.
I have three tables with 190,000+ rows
when I make a collision between them I filter the values are all there.
When I transform into numbers or anything else they reduce to just under 300,000
I use SQL I filter some SAP valuesThat doesn't clarify much.
In general terms I wouldn't know why rows would disappear.
If you want specific help, then you should provide specific information, like some screenshots / fake data with the situation before transformation, the relevant query and/or DAX code, the situation after transformation together with an explanation which specific values disappear and why they shouldn't disappear.
And anytrhing else that may be relevant for you to get help from somebody over here,
I get the information from an SAP DB.
When I use Power Query t change to a Number some column some data
When I change the column type some values it is not able to find when it was text and it returns no error or blank cell
I have repeated the same project several times and the error persists.
=/