Forum Discussion
MRR Revenue Growth
- 1 year ago
I think I have just managed to get a step further:
test 2024 = CALCULATE([MRR Revenue2],Date2[Year]=2024)I had the idea to use a measure and claculate to reference the other measure but filter it by year. As you can see this worked.
However if I then use these measure in a growth measure to get a percentage by filtering on the last 6 months like this:
Growth = ([test 2025]-[test 2024])/[test 2024]It doesn't give me what I want because its not sum'ing them up. I can't work out how to sum a measure. I think maybe I need to create a virtual table of those measures but couldn't work out the formula:
Hoping someone has an idea please.
- 1 year ago
I feel like I am just spamming at this point but I 'might' have figured it out. Its late so will check in ernest tomorrow but this seems to be working so far:
tester 2024 = sumx(VALUES(Date2[Month]),[test 2024])
I think I have just managed to get a step further:
test 2024 = CALCULATE([MRR Revenue2],Date2[Year]=2024)I had the idea to use a measure and claculate to reference the other measure but filter it by year. As you can see this worked.
However if I then use these measure in a growth measure to get a percentage by filtering on the last 6 months like this:
Growth = ([test 2025]-[test 2024])/[test 2024]It doesn't give me what I want because its not sum'ing them up. I can't work out how to sum a measure. I think maybe I need to create a virtual table of those measures but couldn't work out the formula:
Hoping someone has an idea please.
- Lodan1 year agoHelper II
I feel like I am just spamming at this point but I 'might' have figured it out. Its late so will check in ernest tomorrow but this seems to be working so far:
tester 2024 = sumx(VALUES(Date2[Month]),[test 2024])