Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?!
Solved! Go to 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?
Sorry, I randomly clicked "Accept as solution", the issue is still open
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
..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
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
ASSY | Serials | ## | Total | NEW | R1 | R2 | R3 |
Рђ04892 | 6008451 | 1st run | 1000 | 800 | 600 | 400 | |
6008451 | 2nd run | 1100 | 900 | 700 | 600 | ||
Sum for serial | 6100 | 2100 | 1700 | 1300 | 1000 | ||
9000020 | 1st run | 2000 | 1800 | 1500 | 1200 | ||
9000020 | 2nd run | 1400 | 1200 | 1000 | 200 | ||
Sum for serial | 10300 | 3400 | 3000 | 2500 | 1400 | ||
9000010 | 1st run | 2300 | 2000 | 1600 | 1200 | ||
9000010 | 2nd run | 1800 | 1600 | 1400 | 1200 | ||
Sum for serial | 13100 | 4100 | 3600 | 3000 | 2400 | ||
AVERAGE FOR ASSY | 3200,00 | 2766,67 | 2266,67 | 1600,00 |
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |