cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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:

 

Aggregate = CALCULATE(SUM(TasksInformation[TaskCost]), FILTER(TasksInformation,TasksInformation[TaskFinishDate]<= EARLIER(TasksInformation[TaskFinishDate]) && TasksInformation[ProjectName] = EARLIER(TasksInformation[ProjectName])))
 
Then the result of this column is the following:
 
TaskTaskCostTaskFinishDateAggregate
Task 11001/06/202010
Task 22002/06/202050
Task 32002/06/202050

 

The Aggregate summarization is set to Sum in order to be represented in a Line Chart. The issue is that when is drawn in the chart for the day 02/06/2020 is drawing 100 instead of 50.

 

How could I avoid to sum twice the same amount for the same day? In order to have a linear graph without peaks made by the wrong sum amounts.

 

Feel free to revert for amy further clarification.

 

Thanks in advance for the help.

 

Regards,

 

3 REPLIES 3
Community Support
Community Support

@otgerpeidro ,

 

Change the aggregation type from sum to max or min in the value section of line chart.

 

Regards,

Jimmy Tao

Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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,

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors