Forum Discussion
Ramendra
Helper IV
Helper IVformula context
Hi Team, Can you please help me to know that how to apply below formula in Power Bi for a table Countif(K4:Q29,"<=6")
Hi Ramendra ,
Add an index column in the query editor.
Select the index column and unpivoted other column.
Extract the number after "U".
Converts your selected range to a filter condition in DAX.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ramendra ,
https://community.powerbi.com/t5/Community-Blog/CO-CU-Excel-to-DAX-Translation/ba-p/1080018#M2077
CALCULATE(COUNT('Table[ColumnName),FILTER('Table', Table[ColumnName] <= 6))
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
RamendraHelper IV
Helper IVAnonymous ,
No this is for a range including more than one column.
Can you suggest for this.