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 all,
I have several YTD measures by union I have made a waterfall visual but it is not showing me YTD just actual data for that month.
This is my actual monthly data and YTD table.
ANd here is my YTD Forecast spend -
Hi @baribir ,
please change the calendar date column type to DATE type and use the below DAX formula to calculate YTD
YTD Forecast Spend =
CALCULATE ( SUM ( 'Table'[Forecast Spend] ), DATESYTD ( 'Calendar'[Date].Date ) )
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Regards,
Gaurav Raj Singh
LinkedIN : https://www.linkedin.com/in/gauravrajsingh/
Hi @Anonymous ,
As you see in table format YTD is working and the calculations are correct. The datetable date is in date format.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |