Forum Discussion
Custom Year To Date
Hello -
I'm trying to create a custom Year to Date Calculation/Time Series.
When I create the Custom Measures within Desktop it populates correctly.
YTD = TOTALYTD(SUM(table[sales_amt]),Calendar[WK_END_DATE],"1/31")
But when I populate within Tabular Editor and change out the table/sales_amt with "SelectedMeasure" I get errors/no results.
any advice is appreciated. Thank you.
3 Replies
atp_2006 ,
try like
calculate( Sum(Table[sales) ,datesytd(Calendar[Date],"1/31") ) // Make sue to use date of date Table
Create measures like
M1= Sum(Table[sales)
And create calculation group
calculate( selectedmeasures() ,datesytd(Calendar[Date],"1/31") )
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uATime Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145sCalculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Thanks for you help.
I've tried your way as well. The Dax is accepted, but when I use the filter within the power bi tool it results in no data.
I'm able to hardcode the year with the result I'm expecting, but would like for it to be dynamic.
calculate(selectedmeasure(),'Calendar'[full_yr_nbr]="2022")
