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,870 points • 1,197 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,770 points

Related Questions In Power BI

0 votes
1 answer

I want to calculate the distinct count of active customers but only for the last three completed months—how can I do this in DAX?

To calculate the distinct count of active ...READ MORE

answered Mar 10 in Power BI by anonymous
 • 28,990 points • 117 views
0 votes
1 answer

How can I use DAX to calculate the difference between two non-contiguous periods?

In Power BI, DAX provides the solution ...READ MORE

answered Apr 1 in Power BI by anonymous
 • 28,990 points • 77 views
0 votes
1 answer

How do I calculate the most frequently occurring value in a column using DAX?

To find the mode in a column, ...READ MORE

answered Apr 1 in Power BI by anonymous
 • 28,990 points • 91 views
0 votes
1 answer

How do I optimize the use of complex measures when working with DirectQuery?

To optimize the use of complex measures ...READ MORE

answered Apr 1 in Power BI by anonymous
 • 28,990 points • 63 views
0 votes
1 answer

Error : Function 'GROUPBY' scalar expressions have to be Aggregation functions over CurrentGroup().

The error says you need to use ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
 • 65,770 points • 4,562 views
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
 • 6,524 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,770 points • 23,194 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,770 points • 7,375 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,770 points • 4,789 views
–1 vote
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,770 points • 1,038 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.