(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
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
Printer-friendly version
Send to friendEmail: PPadmin@planningplanet.com
