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.
Hi.
We have a bar chart where we show YTD Current year, YTD last year and YTD budget figures.
However, for the actual YTD figures we would like only to show figures for the previous and currents months. This means that for May-December the red bar should be empty. Is this possible?
The measure for Actual YTD is:
Net sales Local YTD:=CALCULATE(SUM(Invoices[NetSalesLocal]);DATESYTD('Month'[Date]))
Thanks a lot in advance.
Br.
Helen
Solved! Go to Solution.
First, you adjust the YTD to your financial year. Year from May -April will look like
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"4/30"))
Also you can stop it max date of data
YTD Sales =
var _max = maxx(Sales,Sales[Sales date])
return
CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"4/30"),Sales[Sales date]<=_max)
First, you adjust the YTD to your financial year. Year from May -April will look like
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"4/30"))
Also you can stop it max date of data
YTD Sales =
var _max = maxx(Sales,Sales[Sales date])
return
CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"4/30"),Sales[Sales date]<=_max)
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |