Forum Discussion

Riddhi_06's avatar
Riddhi_06
Frequent Visitor
4 years ago

Getting exact column count when columns are more than 1000

How can we get an exact column count when the column count is exceeding 1000 in power bi? In power query it is shown as 999+ What can be done?
Need Help
Riddhi_06's avatar
Riddhi_06
Frequent Visitor
4 years ago

Vijay_A_Verma 
i want the total column count 
like here in the above screenshot 35 columns are present, if there the value is 999+ for columns
how to get the exact count 

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    To get exact count, you need to issue following formula where Custom1 should be replaced by previous step

    = Table.RowCount(Custom1)*Table.ColumnCount(Custom1)

    You can also refer to table directly. In below formula, I have pulled the table from SQL Server

    = Table.RowCount(dbo_DimCustomer)*Table.ColumnCount(dbo_DimCustomer)