Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)
edited by
How can I delete a specific row for a single dataset, Is there any way to do this through an app or can I do it manually

1 Answer

0 votes
by (22.5k points)
edited by

In query, editor use this formula

let
    Source = Excel.Workbook(File.Contents("D:\LTE_FBP.xlsm"), null, true),
    cap_Sheet = Source{[Item="cap",Kind="Sheet"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(cap_Sheet,{{"Column1", type any}, {"Column2", type any}, {"Column3", type any}, …, {"Column941", type any}}),
    #"Removed Top Rows" = Table.Skip(#"Changed Type",3),
    #"Removed Bottom Rows" = Table.RemoveLastN(#"Removed Top Rows",22),
    #"Removed Bottom Rows1" = Table.RemoveLastN(#"Removed Bottom Rows",1)
in
    #"Removed Bottom Rows1"

remove row 2

let Source = Excel.Workbook(File.Contents("D:\_Ulm\# ECE Data Analyst\Power BI\LTE_eNB_Feature_Build_Plan 960051.xlsm"), null, true), cap_Sheet = Source{[Item="cap",Kind="Sheet"]}[Data], #"Changed Type" = Table.TransformColumnTypes(cap_Sheet,{{"Column1", type any}, {"Column2", type any}, {"Column3", type any}, …, {"Column941", type any}}), #"Removed Top Rows" = Table.Skip(#"Changed Type",3), #"Removed Bottom Rows" = Table.RemoveLastN(#"Removed Top Rows",22), #"Removed Bottom Rows1" = Table.RemoveLastN(#"Removed Bottom Rows",1), #"Remove Row 2 only" = Table.RemoveRows(#"Removed Bottom Rows1",1,1) in #"Remove Row 2 only"

remove 2 and 3 

let
    Source = Excel.Workbook( File.Contents("D:\_Ulm\# ECE Data Analyst\Power BI\LTE_eNB_Feature_Build_Plan 960051.xlsm"), null, true),
    cap_Sheet = Source{[Item="cap", Kind="Sheet"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(cap_Sheet,{{"Column1", type any}, {"Column2", type any}, {"Column3", type any}, …, {"Column941", type any}}),
    #"Removed Top Rows" = Table.Skip(#"Changed Type",3),
    #"Removed Bottom Rows" = Table.RemoveLastN(#"Removed Top Rows",22),
    #"Removed Bottom Rows1" = Table.RemoveLastN(#"Removed Bottom Rows",1),
    #"Remove Row 2 only" = Table.RemoveRows(#"Removed Bottom Rows1",1,1),
    #"Remove Row 3and4" = Table.RemoveRows(#"Remove Row 2 only",1,2)
in
    #"Remove Row 3and4"

For more information on Power Bi, check the following  Power Bi Training

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Nov 22, 2020 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...