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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ChrisNZC
Advocate I
Advocate I

Average $ Multipled by No. of Months Remaining

Hi,

 

I'm struggling to get the value I want from DAX.

I have a column (un-summarised) with the number of Months remaining for each customer.
I have a measure to calculate the Average $ spend over the months they have already spent.
And I have attempted to calculate the average spend, multiplied by the number of months remaining.

The goal is to predict how much spend we will have as a total, based on each customers average spend, multiplied by their number of months remaining.

 

ChrisNZC_1-1611203031328.png


My rows are calculating, but the total of $850,889.62 is clearly not correct.
My total should be $69,604.09 (final column sum).

How can I achieve this? My data is is spend by grouped by customer and month.

 

1 REPLY 1
wdx223_Daniel
Super User
Super User

=sumx(summrize(table,table[month],table[customer]),[months remaining]*[average $ per month])

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors