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
