87341/how-do-i-use-the-dax-function-parallelperiod
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
Hi, You can create interactive reports out of ...READ MORE
Try this: 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
Hi,@ Obi First do not get anxious, clam ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.