Database Reference
In-Depth Information
2. Move to an open cell and enter the following expression. This measure will
calculate the sales amount for a period of time exactly one year earlier than
the current period.
Sales Prior Year:=CALCULATE([Sales Amount]
, SAMEPERIODLASTYEAR(
'Date'[FullDate] )
)
You can experiment with Excel and visualize the model in different ways. In the
following example, after opening Excel, I added a PivotChart, chose a line chart,
and added the
FullDate
field from the
Date
table to the chart axis. I added the
Sales Amount
and
Sales Prior Year
measures from the
Internet Sales
fact table. Via the
PivotChart Tools
|
Design
ribbon, I inserted a timeline based on
the
FullDate
field in the
Date
table.
You can see that by comparing the
Sales Amount
values side-by-side with the
previous year in the
Sales Prior Year
measure, we can see that sales have in-
creased significantly; using the timeline, we can compare sales with the prior year
for a more specific period of time.
Search WWH ::
Custom Search