Table organisation and row elimination

ALVMRB — Wed, 28 Feb 2024 21:54:42 GMT

Hi everyone I have the next data :

JON	0
MAR	1
JUAN	0
ALF	1
ALF	1
PEP	0
PEP	0
VA	0
VA	0
PA	0
PA	1
CTA	1
CTA	1
AR	0
NSA	1
NSA	1

I would like to do the next things: eliminate rows with 0 and eliminate rows that have a repeated name, I´ve tried many ways in different order. However, I don´t have a effective way, I would be please if some helped me to solve this problem.

Thanks for reading

Re: Table organisation and row elimination

lbendlin — Thu, 29 Feb 2024 01:20:18 GMT

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8vL3U9JRMlCK1YlW8nUMArINwWyvUEeEhKOPG1wCmR3gGgBXg8wOc8TGDEBjQsxwDsHOBrsFotovGCEMZ8cCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Item = _t, Value = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Item", type text}, {"Value", Int64.Type}}), #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Value] <> 0)), #"Removed Duplicates" = Table.Distinct(#"Filtered Rows", {"Item"}) in #"Removed Duplicates"

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the Source step with your own source.

topic Table organisation and row elimination in DAX Commands and Tips

Table organisation and row elimination

Re: Table organisation and row elimination