Forum Discussion
Countrows in multiple column based on partial text value
Dear all, For a project I need to be able to count the number of rows in a file, based on a text value in one of eight defined columns. I want to count a row when one of the "Linked Issues" colu...
You can convert your table to look like below using Unpivot Columns option in Power Query Editor
Refer below link
Post that you can use the below DAX to get the ouput that you were expecting. In this case there are 5 combinations having "THGRW" in them
I have a strange problem before I want to start unpivotting columns. The following formula gives me the correct number of rows. But whenever I change it to [Linked Issues.2] or another number, the formula returns a blank.