Forum Discussion
Sum issue
Hi Folks, Trying to do something with 6 stock periods, though the table below only shows 3. I have employees that have 6 columns of shares with different vest dates. What I want to do is Sum acro...
it required unpivot of data and then it is easy, i quickly put together pbix for your reference, change it as per your need.
https://drive.google.com/open?id=0B4dPgH9_BPBrOG9rR01HOGFjOGM
Thanks parry2k, but I can't undo the data like that because the sum of shares for each employee needs to be rolled into a table visual with other employee data. There are thousands of rows and I get new feeds daily so need to automate it better some how.
There must be a different way to create it as a measure so that I can plop it in a table visual...