Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Aggregating calculated data

I am tring to aggregate data I have in a column by adding the data in the current row to all the previous rows. Sample data below shows the data in the Done column that I would like to aggregate to p...
Need Help
Show and Tell
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

Could you share your file so that we could help further on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

 

Regards,

Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cherie, I have uploaded my data. The CFD page is where I am working on this dashboard. The Datekey table is a new one I created trying to get this to work. The other two tables are from our projects database, plus some columns and measures I have created.

 

Thank you for all your help with this.

 

-Greg

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous

     

    I cannot access the file. You can upload the .pbix file to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

     

    Regards,

    Cherie

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Cherie, I do not know how to mask the data, hough, I don't think anything sensitive is in it. Still, I would prefer not to have an open link posted on the board. Can you share an email so I can just send you the link? You can email me at [email protected].

     

    Thanks,

    Greg

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous

     

    You may send the link via private message.

     

    Regards,

    Cherie