Forum Discussion

Lodan's avatar
Lodan
Icon for Helper II rankHelper II
1 year ago
Solved

MRR Revenue Growth

Hello,   You helped me out previously (thanks a lot for this) when I needed to be able to track revenue by month / year but cumulating via start and end date of that revenue.  That is in the PBIX f...
Need Help
Lodan's avatar
Lodan
Icon for Helper II rankHelper II
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.

  • Lodan's avatar
    Lodan
    Icon for Helper II rankHelper II
    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])