Project Online odata - recreate cumulative calculated field from Service in Desktop

[snetsmart]

Hi all,

I've created many different interpretations of this in Desktop, but *something* is ellusive in duplicating this calculated field/cumulative visual that comes standard in the Service version. I can see totals for each day, but cannot figure out how to get the running total, day over day, for the life of the project, to work. Can anyone help me figure out the DAX behind it, and/or what fields are used from the odata data model?

I have a separate table built for Date Dimension and it's joined to the various date fields in the timephased data tables.

 Thanks!

Stefanie

[v-qiuyu-msft · Accepted solution]

Hi @snetsmart,

In your scenario, you need to create a measure to calculate running total in Power BI Desktop instead of Service. Generally, we can define DAX like below:

Cumulative Quantity :=
CALCULATE (
    SUM ( Transactions[Quantity] ),
    FILTER (
        ALL ( 'Date'[Date] ),
        'Date'[Date] <= MAX ( 'Date'[Date] )
    )
)

Also you can adjust DAX based on your real scenario, you can take a look at this article to check which pattern is more suit for you: Cumulative Total.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu