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.
Hellor
I need some help with this problem: I have many users and each one has made, at least, one purchase at some point, I need to know the date of the first purchase they have made to count the amount of first purchaces made in a month.
OG table
User | purchase_date |
A | 2023-02-01 |
A | 2023-02-14 |
A | 2023-03-29 |
B | 2023-02-10 |
C | 2022-12-23 |
C | 2023-07-04 |
C | 2023-09-15 |
First purchase table
user | "first_purchase" |
A | 2023-02-01 |
B | 2023-02-10 |
C | 2022-12-23 |
Probably this is not the best way to do this, if someone can guide me to something I can study to achieve this goal is very appreciated.
Solved! Go to Solution.
You can produce your required output by the following table dax formula.
In this simple data model, I separately created a calendar table (dimension table) and created a one to many relationship with the fact table because it is the best practice to do so.
I omit detailed explanations here, but instead, please find attached the link to the pbix file, and please let me know if anything is unclear.
You can produce your required output by the following table dax formula.
In this simple data model, I separately created a calendar table (dimension table) and created a one to many relationship with the fact table because it is the best practice to do so.
I omit detailed explanations here, but instead, please find attached the link to the pbix file, and please let me know if anything is unclear.
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
18 | |
15 |