Count number of values in Column if another Column contains X

[android1]

Hi,

I have 2 columns, Num Hrs & DayName. How do I count the number of hrs in Num Hrs if DayName = Sunday?

Num Hrs is in Duration format, DayName is Text.

Regards,

Gerry

[MarcelBeug]

Just filter and sum (I think you mean "sum" instead of "count"):

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Num Hrs", type duration}, {"Day", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Day] = "Sunday")),
    #"Calculated Sum" = List.Sum(#"Filtered Rows"[Num Hrs])
in
    #"Calculated Sum"

[android1 · Accepted solution]

Hi,

Thanks for the reply. Yeah, SUM is what I meant. I have what I need using - Sunday Hrs = CALCULATE(SUM(CarerActualWork[Num Hrs]),CarerActualWork[DayName] = "Sun")

Thanks anyway.

Gerry

[v-yuezhe-msft]

Hi @android1,

Glad to hear the issue is solved.  You can accept helpful replies as answers to close this thread.

Thanks,
Lydia Zhang