Forum Discussion
Running Total restart each year
- 6 years ago
To use this Time Intelligence function you need a proper Date table and reference the column that has marked as the date column (not possible with a column like you showed in your picture).
If you're not prepared to work with such a table, you'd have to add a year-filter into your original measure like so:
TRACKED_LOANS running total in Year Quarter = CALCULATE( SUM('FACT_Unique Tracked Loans'[TRACKED_LOANS]), FILTER( ALLSELECTED('DIM_Date'[Year Quarter]), ISONORAFTER('DIM_Date'[Year Quarter], MAX('DIM_Date'[Year Quarter]), DESC) ), FILTER( ALL('DIM_Date'[Year]), 'DIM_Date'[Year] = MAX('DIM_Date'[Year]) ) )
You can use datesytd and totalytd, It will restart after year
YTD Sales = CALCULATE(SUM('FACT_Unique Tracked Loans'[TRACKED_LOANS])),DATESYTD(('DIM_Date'[Date])))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin