Forum Discussion
Create total column(s) (Like Excel's CountIF() )
Hey Power BIs, I am very new to Power BI and come from Excel. Hi. I have been spending days trying to accomplish what would take me seconds to do in Excel - with zero progress. I want to create ...
Anonymous Yeah, Power BI works better if you unpivot those columns. Then it is trivial. Otherwise, you need to use MC Aggregations: https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-p/391698#M129
Anonymous Yeah, Power BI works better if you unpivot those columns. Then it is trivial. Otherwise, you need to use MC Aggregations: https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-p/391698#M129
Hmm.. Interesting.
Thank you.
Funnily enough, this is the unpivoted data. I unpivoted it to establish a relationship with other tables.
Just to clarify, I have thousands of columns. Is this still the way? At first glance, that seems like a lot of typing.