Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@pema012 , Check if these functions can help
Power Query Table.ColumnCount, Table.ColumnNames, Table.ColumnsOfType- https://youtu.be/HGEj81PO_6E
@pema012 , Check if these functions can help
Power Query Table.ColumnCount, Table.ColumnNames, Table.ColumnsOfType- https://youtu.be/HGEj81PO_6E
User | Count |
---|---|
97 | |
87 | |
78 | |
74 | |
70 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |