Hi , i have a Datatable imported into Powerpivot, where i need for 6 columns a conditional count for each row, my formula in Excel is similar to
=COUNTIF([Q1]:[Q6]),"")
I have big issues doing the same in Powerpivot, can anyone help? - i tried with COUNTX to no avail
=COUNTIF([Q1]:[Q6]),"")
I have big issues doing the same in Powerpivot, can anyone help? - i tried with COUNTX to no avail