Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi, i need help to calculate a formula. Sum the months of same value in dax
i need this result:
=sum (MonthValue *MonthsApply) / total months
In this example, would be:
=((1000*2)+(2000*1)+(2500*2)) / 5
Month | Value |
Jan | 1000 |
Fev | 1000 |
Mar | 2000 |
Apr | 2500 |
May | 2500 |
Solved! Go to Solution.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @felipesaw
this is the same as ( 1000 + 1000 + 2000 + 2500 + 2500 ) / 5 which equals to
AVERAGEX (
VALUES ( 'Table'[Month] ),
[Value Measure]
)
User | Count |
---|---|
16 | |
14 | |
13 | |
12 | |
11 |
User | Count |
---|---|
19 | |
16 | |
15 | |
11 | |
9 |