Forum Discussion

ukantkumar's avatar
ukantkumar
Icon for Helper I rankHelper I
7 years ago
Solved

Text with Number Count in power query

I need to count

1 st total row = 13

then

 Status using Unit

status is completed and unit not equal to 0 =6

 

like: 

Custom column=List.Count(
List.FindText( [Table name][status],"Completed" )  & List.Number([Table name][unit]<>0))

 

but it is not working?


 

 

 

General Comment

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    7 years ago

    ukantkumar 

     

    Try with

     

    Table.RowCount(Table.SelectRows(TableName,each [Status] = "completed" and [unit]<>0))