Hi See the attached file. Hope it helps Here are the steps Step#1 Determine the First and Last Years with Actual data using these MEASURES FirstYear = FIRSTNONBLANK ( ALL ( YearTable[Year] ), CALCULATE ( SUM ( MeasureTable[Revenue] ) ) ) LastYear = LASTNONBLANK ( ALL ( YearTable...

Zoe Helps Me Answer a Long-Simmering Question This summer we welcomed Zoe Stein (an Industrial Engineering major from Georgia Tech) to the team for a summe

Does anyone have suggestions on how to average the YTD months to a target, and reforecast the remaining months based on that percentage?   For example,   If my first 5 month average sales was $40.00 but I targeted $50, I would take 40/50 and multiple that by next months target, say it was $48. The v...

Hi,   I need to create a report that will show me realised values and estimated values for the rest of the year.   The report should be a table having finance accounts on rows and months in the columns. If the user filter the year to 2017 and month to april the first 4 columns should show realised v...

Hello,   I want to calculate the following: the average for the last 3 months and i want to project this data for the rest of the year.   For example: the data for the first 3 months is real data   jan    feb   mar     apr     may     jun    jul 10      20    30        20      20       20     20   I...

Hi, I need to represent a report that shows weekly trend of YTD average of a sales per region. Any advise on how can I use Power BI to help me? This is the example   Region    Day    Sales Amount A             1         1000 A             2         1500 A             3         700 B             1   ...

Scenario A retail firm believes that its sales are driven by an external index that we will call the "Real Wage Index". This index tracks real hourly wages adjusted for inflation, seasonality, etc. The retail firm believes that this index is a 3-month leading indicator, meaning that when the index g...

Technical articles, content and resources for IT Professionals working in Microsoft technologies

Back to Part 1 Download this workbook Here The Formula for the Slope of a Linear Regression Line.  It’s Greek to Me.(Get it?  Gree

Power BI and R – Part 1 (Intro) http://blog.janmulkens.be/power-bi-and-r-part-1-intro/

Use R to export data from Power BI (and Power Query) http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/