Forum Discussion

sokatenaj's avatar
sokatenaj
Icon for Advocate II rankAdvocate II
8 years ago

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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Well I'm more than happy to help but still not very clear what is not working and what the challenge is. may be share your pbix file with some sample data, that might help. 

sokatenaj's avatar
sokatenaj
Icon for Advocate II rankAdvocate II
8 years ago

I know, but I need it as a measure as I am not doing pivots or using it as a visual. It needs to be used as a field in the main Table visual, not as its own. I can use your method if I needed to do it as its own visual as you have it laid out, but not in this case. 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    not sure why you stuck it that you need it as measure. anyhow just added it as a "Total Shares" measure and updated pbix.

  • sokatenaj's avatar
    sokatenaj
    Icon for Advocate II rankAdvocate II
    8 years ago

    Thanks parry2k. I'm just going to do this a different way by just deleting the data in the document prior to Nov 1 2017 and using SumX. 

     

     

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    Sounds good.

     

    Good luck!