Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
scabral
Helper IV
Helper IV

PARALLELPERIOD and multiple dimension values

HI,

 

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 = 

CALCULATE ( SUM('FE Values'[BIM PD (Owned)]),PARALLELPERIOD (FE Date'[Date],-1,YEAR))

 

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:

 

ParallelBefore.PNG

 

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:

 

ParallelAfter.PNG

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.

 

Scott

 

1 REPLY 1
lbendlin
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

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.