Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
There are five tables in my database:
Bill, Subscription, User, Credit card & Sites
In Subscription table, there is "type" column which contains below values:
Over time our users have paid the varying amount within these subscriptions type. There is a “schedule” field where we tell you if it is a monthly or yearly plan.
You will also need to note that Bills have a column called “status.” The different statuses that a bill can have are:
I have set value according to above status in calculated column "Amount Corrected"
Required Calculation: Need to find by looking for sites that are paying their very first bill through one of our paid subscriptions. Note: for annual plans, we will need to split the payment into 12 equal parts.
I have created a measure "New MRR", it shows aggregate value for all date, but I need to show value only for the first bill date.
Please Guide
Thanks in advance!
Please find the .pbix file link:
https://www.dropbox.com/s/b7blkkv32dcmkzw/Leith.pbix?dl=0
Solved! Go to Solution.
Hi @Anonymous,
Please try below measures:
first bill at = CALCULATE ( MIN ( bills[bill_at] ), ALL ( bills[bill_at] ) ) First MRR = CALCULATE ( [New MRR], FILTER ( ALL ( bills[bill_at] ), bills[bill_at] = [first bill at] ) )
Best regards,
Yuliana Gu
Hi @Anonymous,
Please try below measures:
first bill at = CALCULATE ( MIN ( bills[bill_at] ), ALL ( bills[bill_at] ) ) First MRR = CALCULATE ( [New MRR], FILTER ( ALL ( bills[bill_at] ), bills[bill_at] = [first bill at] ) )
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |