Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])