Forum Discussion
Anonymous
6 years agoNot applicable
Filtering Cumulative count by date
I'm working my way through the creation of a new report, with significant help from members of this group. I need to produce a Line and Column visual, showing, cumulatively, the number of project ...
v-lili6-msft
6 years agoCommunity Support
hi Anonymous
Please re-upload the attachment, that link seems to be wrong.
For all came out with the same value, you should add a conditional in the formula like this:
Tasks[ProjectName] = MAX ( Tasks[ProjectName] )
If you still have the problem, Please share a simple sample pbix file and your expected output.
Regards,
Lin
Anonymous
6 years agoNot applicable
Hi v-lili6-msft Lin,
Apologies for the delay in responding, I've finally managed to find a solution to the inability to attach files here and have saved the speadsheet on OneDrive, <here>
It contains sample data and field descriptions, as per the screenshots in the posts already sent
Thanks in advance for any help/solution you can provide
Regards
Fred