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
Rustami4
Helper II
Helper II

Average for 3 terms in a row

Hi everyone,

Couldn't get the average for a few terms in a row. PBI is giving me a value for each row, but i need the average for 3 terms in a row. Help me please guys?!

1 ACCEPTED SOLUTION

Hi, Dale. 

How did you define the encircled parameters, I mean is it a separate function or what? Am I supposed to create them separately as a function and after put in the formula above? 

View solution in original post

27 REPLIES 27

Sorry, I randomly clicked "Accept as solution", the issue is still open Smiley Very Happy

Actually I'm sure we chose the right direction

Hi Dale,

I couldn't mange it, when I type this formula it says the formula is too long, and too many values it consists. Have no idea what's wrong. Actually I created very simple measures, such as The Sum of a definite column (measure=Sum (table1(meters)) and so on

Hi @Rustami4,

 

Could you please share some snapshots of the error messages? Or share the .pbix file directly. A dummy one is enough.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

..and only

Hi @Rustami4,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

 

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Dale!

None of the formula above hadn't solved it. Maybe you didnt get the whole idea. I'll try to explain it differently using an example

Let's look at the example below... There is what I'm trying to define..We need to summarize all the same serial's values and determine an average value for summarized serials within one ASSY

ASSYSerials##TotalNEWR1R2R3
Рђ0489260084511st run 1000800600400
60084512nd run 1100900700600
 Sum for serial61002100170013001000
90000201st run 2000180015001200
90000202nd run 140012001000200
 Sum for serial103003400300025001400
90000101st run 2300200016001200
90000102nd run 1800160014001200
 Sum for serial131004100360030002400
        
        
   AVERAGE FOR ASSY3200,002766,672266,671600,00

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.