How do I use the DAX function ParallelPeriod

0 votes

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.

Oct 5, 2020 in Power BI by Rajiv
• 8,880 points
120 views

1 answer to this question.

0 votes

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]
answered Oct 5, 2020 by Gitika
• 65,870 points

Related Questions In Power BI

0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,310 points
244 views
0 votes
1 answer

How do I use Python Visualizations in Power BI?

Hi, You can create interactive reports out of ...READ MORE

answered Apr 8, 2019 in Power BI by Phalguni
• 1,020 points
200 views
0 votes
1 answer

How do I use Python scripts in Power BI?

Hi, You can create interactive reports out of ...READ MORE

answered May 2, 2019 in Power BI by avantika
• 1,500 points
1,471 views
0 votes
1 answer

How do I get my DAX measure to calculate grouped values?

Try this: Total Usage:= SUMX( VALUES(MyTable[SensorID]), [Usage]) An alternative ...READ MORE

answered Oct 8, 2020 in Power BI by Gitika
• 65,870 points
94 views
0 votes
1 answer
0 votes
1 answer

How to get month name from month number in Power BI?

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

answered Sep 24, 2020 in Power BI by Alisha
187 views
0 votes
1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,870 points
5,093 views
0 votes
1 answer

How to ignore a slicer for one measure, but apply it on another?

In order to ignore Slicer you need ...READ MORE

answered Oct 1, 2020 in Power BI by Gitika
• 65,870 points
1,818 views
0 votes
1 answer

In DAX, how do I RETURN the sum of a calculated column from a DAX Table Variable (created via ADDCOLUMN)?

You can access column variables of previously ...READ MORE

answered Oct 8, 2020 in Power BI by Gitika
• 65,870 points
987 views
0 votes
1 answer

How do I prove that I did the assignment?

Hi,@ Obi First do not get anxious, clam ...READ MORE

answered Sep 14, 2020 in Power BI by Gitika
• 65,870 points
77 views