ytd dynamic
1 Topic
YTD
I have put this dax together. YTD AC = TOTALYTD( sumx(FILTER('Append','Append'[view]="actuals"),[Value]), 'FinDate'[Date], 'FinDate'[Date]<TODAY()) I am getting the same result as sumx(FILTER('Append','Append'[view]="actuals"),[Value]) Please can you help with what is missing so that this is dynamic and doesn't need filtering every month? Many thanks,Solved1.9KViews1like10Comments