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,136 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 3 days ago in Power BI by anonymous
 • 19,330 points • 36 views
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,350 points • 1,355 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 • 1,151 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,520 points • 2,520 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,458 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,473 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,039 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,230 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,725 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 • 970 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.