Forum Discussion
Show last value - not sum
5 Replies
- amitchandak
Super User
Anonymous , you can use closingbalancemonth
closingbalancemonth(Sum('Table'[Budget netto]), Date[Date])
Also refer to my blog , in place closingbalanceyear use month, In case days of year use month days and Datemtd in place of datesytd
amitchandak Thank you for your answer.
However, I would still like the column to contain all of the individual values, so that I am capable of YTD and MTD --> budget from start of the year (fiscal) until TODAY and budget from start of the month until TODAY. I dont think that I am capable of doing so using your formula, as it only contains one value within each month?
- amitchandak
Anonymous ,Can you share sample data and sample output in table format? not able to related in screenshot
v-kelly-msftCommunity Support
Hi Anonymous ,
Could you pls advise what is your expected output based on your data?If possible,could you paste your data in an editable format?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
