Data Disappear

Question

Hi all!&nbsp;Well, when I use "Remove Duplicate" in a column some data disappear =/&nbsp;Does Anyone know what it be?&nbsp;Ever happened to anyone?&nbsp;Ty all ;D

anonymous · Answer

I have a column with 999+ rows when I&nbsp;select&nbsp;"remove duplicates" it remove all duplicates and others that are not duplicates.&nbsp;=/

marcelbeug · Answer

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.

anonymous · Answer

I have three tables with 190,000+ rowswhen 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,000I use SQL I filter some SAP values

marcelbeug · Answer

That doesn't clarify much.&nbsp;In general terms I wouldn't know why rows would disappear.&nbsp;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.&nbsp;And anytrhing else that may be relevant for you to get help from somebody over here,

anonymous · Answer

I get the information&nbsp;from an SAP DB.When I use Power Query t change to a Number some column some data&nbsp;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&nbsp;I have repeated the same project several times and the error persists.&nbsp;=/

Forum Discussion

Data Disappear

5 Replies

Related content

Data Disappears

Fabric Ideas disappear

Data Model Pages Disappeared

Disappearing Visuals

Need Help with Data Label Disappearing