cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lcasey Member
Member

Re: Can anyone provide a simple formula that works?

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 :  lcasey@techmillennium.com 

 

I just have no way to download an attachment from the private messages. 

lcasey Member
Member

Re: Simple formulas dont work

Here is my email address:  lcasey@techmillennium.com

 

I cant even reply to your Private Message...

 

Thanks!!!

lcasey Member
Member

Re: Simple formulas dont work

I think Microsoft is restricting the Power BI forums or made some sort of change,

 

Attachments and replying to private messages no longer working.

Super User
Super User

Re: Can anyone provide a simple formula that works?

on your way, I reached out to you in private message in case you want to share your email address in private. anyhow, it is on your way.





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




lcasey Member
Member

Re: Can anyone provide a simple formula that works?

Thanks!!!

 

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!

 

 

Super User
Super User

Re: Can anyone provide a simple formula that works?

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" ))

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Super User
Super User

Re: Can anyone provide a simple formula that works?

Hey Casey,

 

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.

 

Cheers,

P





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




lcasey Member
Member

Re: Can anyone provide a simple formula that works?

Thank You!!!

 

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....

 

 

 

 

01.png

Highlighted
Super User
Super User

Re: Can anyone provide a simple formula that works?

Glad to hear it worked Smiley Happy

 

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.

 

Cheers!

Parv





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




lcasey Member
Member

Re: Can anyone provide a simple formula that works?

Thank you sooo much !!!!    Your workbook is exactly what I needed.  I think I will be using that workbook more than any other file on my computer!!