Microsoft Office Forums - View Single Post - [Solved] Based on Date Entry, Calculate SUM & Percentage

Alansidman · 02-04-2024, 05:34 PM

Power Query Solution for total. Simple math for the other issue =COUNTIF(Table1[2024 Inspection],"<>"&"")/C31

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([2024 Inspection] <> null)),
    #"Calculated Sum" = List.Sum(#"Filtered Rows"[Principle])
in
    #"Calculated Sum"