Power BI running total from PWA data

In the Open Standard

Philip de Havilland-HallMember for 15 years

Hi Team,

I am trying to create a cashflow dashboard in Power BI for the total cost from a set of PWA data.

I have Power BI attached to the database and have created the below DAX code having followed some youtube tutorials:

Cumulative total =

CALCULATE(

AssignmentTimephasedDataSet[AssignmentCost],

FILTER(

all(AssignmentTimephasedDataSet[TimeByDay],)

AssignmentTimephasedDataSet[TimeByDay] < max(AssignmentTimephasedDataSet[TimeByDay])

))

Where AssignmentCost is the cost field, I have used this for a monthly cost and it works.

Am i looking at this in the right way, help please nearly lost a whole day on this.

I have also tried to add a column to the dataset to do the running total using the code below and trying to point it at a specific project:

Rolling total cost = var CurrentDate = AssignmentTimephasedDataSet[TimeByDay]

var FilteredTable = FILTER(AssignmentTimephasedDataSet,AssignmentTimephasedDataSet[TimeByDay]<=CurrentDate)

&& Projects[ProjectName]= "Nimbin Water Main Resintatement"

return

Calculate(AssignmentTimephasedDataSet[AssignmentCost],FilteredTable)

Again no joy please help

Thanks

Replies

Oldest first

No replies yet. Be the first to answer.

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?