Forum Discussion
Contar si en Power BI
Buenos dias
Necesito su ayuda para lograr realizar el (CONTAR SI) que se realiza en excel, en power BI
Hi DuvanPinilla ,
Here's the sample data I created. You want to count the number of H2 in column H.
You could create a measure.
COUNT IF = CALCULATE(COUNT('Table'[H]),FILTER('Table',[H]="H2"))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
DuvanPinilla , I think you need a new column
Use correct column name
example
countx(filter(Table, Table[Column H] = earlier([Column H]) ) ,[Column H])
Hi DuvanPinilla ,
Here's the sample data I created. You want to count the number of H2 in column H.
You could create a measure.
COUNT IF = CALCULATE(COUNT('Table'[H]),FILTER('Table',[H]="H2"))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Me podrias ayudar con esta formulación, ya que no he podido generar un nuevo foro
Necesito obtener los dias de la diferencia de dos fechas teniendo en cuenta los dias habiles, ya logre realizar la columna que muestre la validación de si es dia habil o no.
