Forum Discussion
Cumalative Total - Cannot filter dates
Hi All, I'm very green when it comes to both Power BI and Dax, but I'm attempting to put together a Dashboard which is currently pulling data via ODBC from our ERP system (SysPro). The link is wo...
For the previous year running total, you have to change variables
Previous Year Running Total =
Var __MinDate = Date("2022","1","1")
Var __MaxDateRef = Max('Table'[Date])
Var __MaxDate = DATE(YEAR(MaxDateRef)-1,MONTH(MaxDateRef),DAY(MaxDateRef))
Then use user variable for table and return with SUMX.
Ryaneb85 If this post helps, then please consider accepting it as the solution to help other members find it more quickly.THANK YOU!!