Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper III
Helper III

PARALLELPERIOD and multiple dimension values



i created a measure that calcuates a sum of the previous year value using PARALLELPERIOD function.


below is my measure:


BIM PD (Owned) Previous YearEnd = 



so 'FE Values' is a fact table in the model and 'FE Date' is the date dimension that is related to the 'FE Values 'table (one to many).


If i use the measure with any of the FE Date attributes it works fine, however, when i use attributes from another dimension that is related to the FE Values table i get multiple rows returned because the dimension values changed from the previous year to current year.


Here is the data when using just Year from FE Data and the BIM PD (Owned) and the new measure:




but when i drag in the Divison Name from teh Client Dimension Table (which is also related to the FE Values table), i get this:



so it looks like because the Div Name is different from the previous year (went from Eastern to Central, the grid shows both values.  However, i just want to show the current value for 2021 for any attribute.




Super User
Super User

Remove the Division Name from the visual again?


It's not clear what your desired outcome is. Can you illustrate?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors