We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
Net New ARR =
VAR _Net_Sales1 =
CALCULATE(
SUM(Sales[NetSalesAmount]),
FILTER(Subscription,Subscription[Plan Name] <> "(NCE COM ANN)" || Subscription[Plan Name] <> "(Annual Pre-Paid)")
)
VAR _Net_Sales2 =
CALCULATE(
SUM(Sales[NetSalesAmount]),
FILTER(Subscription,Subscription[Plan Name] = "(NCE COM ANN)" || Subscription[Plan Name] = "(Annual Pre-Paid)")
)
RETURN
_Net_Sales1 * 12 + _Net_Sales2
Someone here helped me come up with this solution, essentially we have 1 Net Sales column that calculates MRR, but it's pulling in and multiplying the annual paid up front subscriptions by 12, so the above formula was a solution to add annual subscriptions to (monthly subscriptions*12)
for some reason it isn't working, I'm selecting a row right now that has an annual purchase of 3000, and the Net MRR measure is showing 36k (It's multiplying annual subscriptions by 12 for some reason) not sure why.
any help is appreciated.
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
20 | |
14 | |
11 | |
5 |