Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
YTD and running Totals
10-26-2023
12:45 AM
YTD Sum RT =
CALCULATE(
SUM('TotalSale+LIS'[Liters]),
FILTER(
ALLSELECTED('TotalSale+LIS'),
'TotalSale+LIS'[Date] <= MAX('TotalSale+LIS'[Date])
&& YEAR('TotalSale+LIS'[Date]) = YEAR(MAX('TotalSale+LIS'[Date]))
)
)
i wrote the dax above in hopes that i would get a running total on my line graph and it worked, but now i would like to show on the same line graph, a line for each year rather than all years as one line. i am struggling to figure out how i can apply, for example, only 2019 dates into this dax. what i have tried so far isnt working, and chat gpt also cant figure this out it seems. any help would be greatly appreciated.
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-26-2023
12:53 AM
you need a year dimension in the visual legend.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-26-2023
12:58 AM
Great, that worked. thanks for the help!!

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
03-02-2016 08:36 PM | |||
06-02-2024 08:34 AM | |||
11-05-2024 03:43 PM | |||
12-23-2024 02:17 PM | |||
09-14-2018 08:20 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
19 | |
13 | |
11 | |
10 | |
7 |