Forum Discussion

Ramendra's avatar
Ramendra
Helper IV
6 years ago
Solved

formula 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")
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    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.

    Sample .pbix

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

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.

Sample .pbix

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ramendra's avatar
Ramendra
Helper IV
6 years ago

V-lianl-msft,

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.