trending

I would like to create a Power BI Report to help with forecasting. Part of what I would like to see is the following based on an input of a specific date any user could enter. Not sure if that's possible in Power BI: - Previous Year (Day) - Not the Date but the Day of the Week for the previous...

Please bear with this explanation as it may be lengthy but I want to be as clear as possible with my problem.. I am trying to detect with a formula the trend over the past 6 months of my data. I do not simply want to see if the data has increased from one month to the next month; rather I want...

Hey guys. I have a worksheet given to me by corporate where they expect us to fill numerous rows in a column each day. Once they are entered we are to compare the last two columns and for each row show whether we are trending up or down in a separate column. Let's say I just filled Column AN...

Hi Everyone, I've included a cleaned version of the workbook I will be using (the native file includes commercially sensitive information) that is identical in layout and structure to the native workbook. I'm trying to set up a workbook that copies information from ['Raw_Data' columns B, D...

I have a somewhat complicated problem that I was hoping some of you may have some ideas for, both in approach and execution in Excel. SITUATION: We have many accounts (70+) each of varying sizes and ticket volumes. Some accounts may have thousands of tickets per week, others may have 1 or less...

Can't figure out how to chart this. Here are a few dates. Followed by an Investment Account. Then the spot price of two metals. The Account represents the total value of over a dozen mining stocks. Some stocks are pure play for one metal. Some have a 30% 70% mix of both metals. We are trying...

First, this is long, but I want to be as descriptive as possible. This modeling is explores using basic attendance data to enrich decisions (which folks to call to keep attendance up). THE PROBLEM/QUESTION: I need help in #excel.I'm using MS Office 2013 and want to model attendance records...

Hi Everyone, I am working on a pharmaceutical inline forecasting project and need some readily available trending tool which can trend on monthly level considering different trends (best fit should be selected automatically) and historical seasonality. I have created one and want to share with...