Theres no attachment in the message either. Everything is Broken Today. I guess I have to leave my email here for all to spam.
If you could send the file to : email@example.com
I just have no way to download an attachment from the private messages.
Ill take a look. If you are interested in making money let me know. I can send cash your way to assit with formulas. Perhaps through Paypal or something.
At this point I dont think DAX is really going to be able to solve our needs but I am willing to pay someone to try!
You should add the third optional argument in your measure to count the balances as of 12/31/2015.
CALCULATE[Current Balance USD],DATESYTD ( 'Date'[Date], "12-30" ))
Appreciate the offer but I'm ok to help without any money, let me know what exactly you need, you have my email address, feel free to send the informaiton and I will do my best to get it going.
mPrevious Year = CALCULATE(SUM(Transactions[Receivables Balance(USD)]),ALL('Calendar'), PARALLELPERIOD('Calendar'[Date], -1,YEAR))
I cant beleive this. I litterally woke up at 8:00 am this morning, read every possible article on Previous Balance and your PBIX file provided exactly what I was looking for!!! The numbers are all Correct Now....
This does work....
Glad to hear it worked
I would have posted the formula but wanted to make sure you understand other internals as well, like table relationships and relationship type because I'm sure you will be doing this many times in the future.