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.
Hi,
My task is to Calculate Total of customers whom:
made orders 1-5
made orders 6-10
made orders 11+
The result that I expected to see how many customer whom made 1-5 orders, 6-10, 10+ of each month
This is the result that I expect. I made it in Tableau.
here is the file for you to have better understanding.
Could you show me which calculation formula should I use to segment customer like this?
Data I use is: sample_superstore
Hope to hear from you and Thank you for reading!!
I think the easiest way is to create a table with date periods as input
Name Start count End count
M1 1 5
M2 6 10
Then create a table reference that has as output something like :
Cust 1 - PO5
Cust 2 - PO6
Cust 3 - PO7
Cust 1 - PO 8
Then create a new VAR with as table reference the previous created table. Add a column with count PO for cust:
Cust 1 - PO5 - Count 2
Cust 2 - PO6 - Count 1
Cust 3 - PO7 - Count 1
Cust 1 - PO8 - Count 2
Then it would be a 'simple' distinct selectcolumn on Cust with a filter similar to the set date periods. It will take you some time probably, but it would be a solution to your problem.
Hi,
Thank you for your reply,
Could you make it in a workbook and send it to me?
cause it is quite vague for me to imagine.
All filesharing possibilities that go outside the company is limited thus I wouldn't be able to share it with you. Let me see if I can create an expression as example...
You can share it when you back home.
I am using dta: sample_superstore
Hmm, stuffing it in a measure is the better solution. I've tested the measure for multiple months and it seems to be working. Still, the intermediate table references mentioned are still there.
Hi,
Thank you for spending time to help me!
if you got the workbook that is much better for me.
Cause seeing from the work that you do, I wonder what is PO?
As mentioned, Power BI doesn't support other file type to be uploaded than photos and videos, so I can understand your wish but I can't execute it :).
PO would be the abbreviation of Purchase Order.
How about Cust1 , Cust2? How could I able to substitute.
In my case, I calculate by Customer ID.
The Cust should be the Customer ID :).
I wasn't able to download your pbix due to the IT settings over here.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |