Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to create a chart showing the running cummulative total by day for the current fiscal year. Here is the measure I am using:
Total Proposed Project Costs YTD = TOTALYTD( [Total Proposed Project Costs], CalendarSubmitted[Date], CalendarSubmitted[Date]<=Today(),"6/30")
I made my chart axis CalendarSubmitted[Date], but the chart shows everything from the beginning of the fact table. I want it to just show this year by date. I don't want to have to manually change the filter on the graph every time the FY changes. How do I incorportate that into the measure? And I ultimately want to add another line with a Last YTD measure.
I
Hi @kman42
Would you like to show total Ytd values for current year
(eg, this year2019, show Ytd values from 2019/1/1 to today)
Measure = TOTALYTD([sum cost],'calendar'[Date],'calendar'[Date]<=TODAY()&&YEAR('calendar'[Date])=YEAR(TODAY()))
Or for current year 2019, show values from 2018/7/1 to 2019/6/30?
Closer to the latter. For the current year (2019), I want to show FY 2020, which runs 7/1/2019 to 6/30/2020. I also want to show Last YTD on the same graph as a different line. My CalendarSubmit table has a column for FY, so:
Date FY
8/1/2019 2020
5/1/2019 2019
Hi @kman42
Create two measures
CY_YTD-TODAY = CALCULATE ( TOTALYTD ( [sum cost], 'calendar'[Date], 'calendar'[fiscal year] = YEAR ( TODAY () ) + 1, "6/30" ), FILTER ( 'calendar', 'calendar'[Date] <= TODAY () ) ) LY_YTD = TOTALYTD([sum cost],'calendar'[Date],'calendar'[fiscal year]=YEAR(TODAY()),"6/30")
I'm getting closer, but it's still not right.
I'd like both lines to start on the graph in July 2019, so I can direclty see how this year is doing compared to last year by the same point in the year.
I set the filter on the graph to relative date filtering for dates in this year, but that leaves the tail on the left. I want the graph to start on July 1 of whatever current fiscal year we are in (currently 2020).
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |