Forum Discussion
formula context
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)
Anonymous ,
No this is for a range including more than one column.
Can you suggest for this.
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.Thank you for your help.
It was a great idea to unpivot columns to convert multiple columns in to one and then to apply formula to a final column and I got the expected output as per my requirement.
