Forum Discussion
Dynamically Sum Columns based on Slicer
Alright, I have several columns: Location Approved Budget SD Budget SF Budget LA Budget OC Budget IE Budget BFD Budget Approved Budget should be a meausre that sums sd, sf, la, oc, ie,...
Hi Anonymous , you might want to use Power BI's ETL tool to split up the strings in the location column first. It will be easier to create the measure.
Anonymous split how? Into different columns? What are you imagining?