Forum Discussion
Power BI with Microsoft Project Online Aggregate Columm wrong Summarization
Hi all, I'm integrating Power BI and Microsoft Project Online and I have created a column which aggregates the sum of cost of each Project's task using the following calculation: Aggregat...
otgerpeidro , You can try like
sumx(summarize(Table, Table[Date], "_1", sum(Table[Aggregate])),[_1])
But I think you need to have an additional grouping of project id or something similar to that
Hi amitchandak ,
When you say to try this sumx(summarize(Table, Table[Date], "_1", sum(Table[Aggregate])),[_1])
Where should I try it? sorry I don't get your answer.
Thanks.
Regards,