Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Buenos dias
Necesito su ayuda para lograr realizar el (CONTAR SI) que se realiza en excel, en power BI
Solved! Go to Solution.
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.
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.
@DuvanPinilla , I think you need a new column
Use correct column name
example
countx(filter(Table, Table[Column H] = earlier([Column H]) ) ,[Column H])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |