Forum Discussion
Count how many columns until value changes
Hi all! My colleagues and I want to use PBI for analysing some internal checks we're running on a monthly basis. For this we're using MS Forms which acts as the data input for PBI. The file we rec...
Anonymous - Not sure about Power Query, I did something similar in DAX called Chtulhu - https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/m-p/509739#M211
Seems like you might want to consider unpivoting columns.