count columns by type

[pema012]

Hi,

I'm all new to Power BI so please bare with me.

I've got a table with mixed columns mostly text and Int64.

I want to count all the columns that are Int64 and calculate the sum times 5.

So,

If I've got 5 columns with int64 the result should be 25.

Then if I add a column the result should be 30 and so on.

This is probably an easy task but my experience of Power BI and Power Query is just above none at all.

Can someone please help me explain how to do this?

Regards,

Peter

[amitchandak · Accepted solution]

@pema012 , Check if these functions can help

Power Query Table.ColumnCount, Table.ColumnNames, Table.ColumnsOfType- https://youtu.be/HGEj81PO_6E