Facebook Countif Like name <> null

---

epod184 wrote:

Hi,

 

I'm having some trouble setting up some Facebook integration to a Power BI report.

 

I've followed the extensive Power BI guide, but it appears the Facebook API has changed since then, and it doesn't work the same way.

 

I am trying to count the amount of "likes" each post recieves, but the Power Query aggregate count function is counting nulls.

 

is there a way to edit the code below so it only counts if the name is not null?

 

= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count, "Count of name"}})

aybe something like:

= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count("name"<>null), "Count of name"}})

Thanks!

---

epod184

Instead of the AggregateTableColumn, you could try to add an custom column as

=Table.RowCount(Table.SelectRows([likes], each [name] <> null))