Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

Count Occurence and Divide

Dear all,   I have the table in the following link: https://docs.google.com/file/d/1x0EfK8yFfP3AKcuFiGLOV7SzbV-yz2Cn/edit?usp=docslist_api&filetype=msexcel   What I need to do is: Count the n...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    1 year ago

    You may use below code

    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Merged"}, {{"Count", each Table.RowCount(_)}, {"Result", each [Volumes]{0} / Table.RowCount(_)}})
in
    #"Grouped Rows"
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
1 year ago

You may use below code

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Merged"}, {{"Count", each Table.RowCount(_)}, {"Result", each [Volumes]{0} / Table.RowCount(_)}})
in
    #"Grouped Rows"
  • Mic1979's avatar
    Mic1979
    Post Partisan
    1 year ago

    Wow many thanks for your help.