Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |