cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

## Cumulative change by quarter using ProductX of measure?

Hello, I have a measure calculating the quarter on quarter unit price changes (call it Measure1). I now want to make another measure (Measure2) that multiplies (1+ values of Measure1) in all quarters up to the selected quarter. Sample data below:

 Year-Quarter Unit Price (Measure1) Measure2 (output) 2022 Q1 - 1+0% = 100% 2022 Q2 30% (100%)*(1+30%) = 130% 2022 Q3 15% (100%)*(130%)*(1+15%) = 149.5%

``````Measure2 =
// Variable for (1+Measure1) value
VAR _n = IF(ISNUMBER('Calculations'[Unit Price]), 'Calculations'[Unit Price] + 1)

RETURN CALCULATE(PRODUCTX(
FILTER( ALLSELECTED('Date'[DecimalDate]),
'Date'[DecimalDate] <= SELECTEDVALUE('Date'[DecimalDate]) ),
_n) )``````

My returns Measure2 output is ridiculously large numbers. Snapshot hereI cropped out the row names but each row represents a different supplier. My data starts at 2019 Q3 so Measure 2 should equal (Unit Price + 1) for that quarter. Everything after that should be a product building off of it. But you can see some funky numbers (eg row 2).

Super User

You can't really put SELECTEDVALUE into a CALCULATE.  Use variables instead.

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors