YTD Total

Question

Hi All&nbsp;I need to get a year to date total not in an ordinary way:&nbsp;YTD Profit = var _numMonths = SELECTEDVALUE('Date'[Date].[MonthNo])RETURNCALCULATE([Profit After Tax]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,VALUE(SELECTEDVALUE('Date'[Date].[Year])) = VALUE(YEAR('Trial Balance'[Period Date]))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,SELECTEDVALUE('Date'[Date].[Month]) &lt;= 'Trial Balance'[Month]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,DATEADD('Date'[Date],-8,MONTH)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp;Based on the Month selected, I would like to know the month number and run the dateadd iteration that many times whhile I sum up the values.&nbsp;Any suggestions will greatly be appreciated.

amitchandak · Accepted Answer

Lancelot , You can have measure like 
&nbsp;
YTD Profit = CALCULATE([Profit After Tax],DATESYTD('Date'[Date],"12/31"))
&nbsp;
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period, Custom Period till date: https://youtu.be/aU2aKbnHuWs&amp;t=145s

Forum Discussion

YTD Total

1 Reply

Related content

Cummulative YTD Totals By Month Error

DAX - Running Total YTD

YTD DistinctCount not totaling correctly

YTD Running Totals

Total YTD with USERELATIONSHIP