Distict of one column or all the columns

[Bharathi09]

Hello All,

I have one qlik script as below

LINK:
LOAD Distinct
KEY,[En Number],[SEQ NUMBER],[ Date],TYPE
Resident TAB_FACT;

It means it takes distinct of only ace_key or all the columns?
In Type tho I have only two records
In seq number, i'll be having many numbers and En Num, Date also many values


If i need to do same in pbi, how can I replicate the script ?

[Or]

Distinct applies to an entire record, same as it would in SQL. If you're looking to "distinct" based on a single field, have a look at using NOT EXISTS.

[Bharathi09]

I have to take same Qlik script in PBI that I have written above , how can I do that?

Please help
Thanks!

[Or]

If you need help with PBI, perhaps try a PBI community? We can try and help with Qlik here...

[TauseefKhan]

1- Go to the Power Query Editor.

2- Use the Remove Duplicates feature to get distinct rows based on the KEY, [En Number], [SEQ NUMBER], [Date], and TYPE columns.