I have created a bog simple PowerPivot SQL Server 2008+ source query and named it Source. The query generates 168 rows: 6 IDs (100-600) and 28 dates (first of a month from Jan 2010 to Apr 2012) all cross applied together.
The DAX expression you used in the derived column should be a measure and defined in the calculation area...
MeasurePriorPeriodValue := CALCULATE(SUM(Source[value]), PARALLELPERIOD(Source[eventDate]
format the KPI by selecting the paint ...READ MORE
You can create interactive reports out of ...READ MORE
Total Usage:= SUMX( VALUES(MyTable[SensorID]), [Usage])
An alternative ...READ MORE
The error says you need to use ...READ MORE
You can use:
MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE
If the tables are related, this is ...READ MORE
In order to ignore Slicer you need ...READ MORE
You can access column variables of previously ...READ MORE
First do not get anxious, clam ...READ MORE
Already have an account? Sign in.