I am building a bank covenant report, I’ve got all my formulas to work except 1. I need the formula to be Current month-prior month total liabilities, however since my Columns is pulling Time Perspective YTD it is not pulling correctly and it is totaling my total liabilities by month for the year and subtracting just 1 month. I am currently using a lag formula, do I need to do an MDX formula? Any suggestions are welcomed!
2 Likes
Have you tried using the “Get Data” option? I use this for reporting to pull in Billings from the Prior Month.
2 Likes
I have not tried that option. I currently have a consultant looking into it! I will make sure to post what the outcome is! Thank you
I solved a similar problem by creating a new Named Time Set. You have to maintain this monthly, but simple to do. Create a Prior Month Y-T-D Named Time Set and define it as January to the month before current. Not sure if this will work in your instance.
2 Likes