Forum Discussion

Lodan's avatar
Lodan
Helper 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...
  • Lodan's avatar
    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
    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])