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

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

Reply
Austinehype
Helper I
Helper I

Cummulative calculation

Hi!

 

I have a list of data where I need to sum the revenues of 3 product types and then multiply with a specified multiplier cumulatively.

21321312.JPG

3 Measures:

 

1. Measure: Sum the last month's total revenues and then multiply with the specific multipliers based on the product type it could be 40% or 60%

 

2. Measure Sum the 2 months ago total revenues and do the same

 

3. Measure sum the 3 months ago total revenues and do the same

 

 

1 REPLY 1
lbendlin
Super User
Super User

@Austinehype Please provide sample data in usable format (not as a picture - maybe insert into a table?) and show the expected outcome.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.