Forum Discussion
Power BI running total from PWA data
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 follow...
Hi,
The issue there is that I am dealing with data that comes from the Project Web Application (PWA).
The adat set is huge even for the small amount of projects I currently have in there.
The expected result would be a month by month running total of the project cost...
Ashish_Mathur
Super User
Super UserHi,
This pattern should work.
- Create a Calendar Table and write calculated column formulas for Year, Month name and Month number. Sort the Month name by the Month number
- Create a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table
- To yoru visual, drag Project, Year and Month name from the Calendar Table
- Write these measures
Total = sum(Data[Total])
Total YTD = calculate([Total],datesytd(Calendar[Date],"31/12"))
The YTD calculation would restart in January each year.
Hope this helps.
Thanks I will give that a shot.
As my daata already has Time by day in the table could I use that perhaps or am i trying to overcomplicate this...?
- Ashish_Mathur
You are welcome. You will need a proper date column (without a time stamp)