Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I would like to track the first time uptake of a product by a customer in a given year e.g. 2018. The idea is to see what volumes are coming in for a product for the first time from a customer. In other words what volume of transactions in 2018 is due to new sales.
Source data
Company CompanyID Product TransactionDate
ABC | 1 | ProdA | 2017/01/17 |
ABC | 1 | ProdB | 2018/02/03 |
ABC | 1 | ProdC | 2017/03/01 |
XYZ | 2 | ProdA | 2017/02/01 |
XYZ | 2 | ProdA | 2017/03/01 |
XYZ | 2 | ProdA | 2017/04/01 |
DEF | 3 | ProdC | 2018/03/01 |
DEF | 4 | ProdB | 2018/04/01 |
Desired Results
Product FirstTimeUsage2018
ProdA | 0 |
ProdB | 2 |
ProdC | 1 |
Any help would be appreciated.
Solved! Go to Solution.
@clivebredenkamp,
Please check DAX in the following PBIX file.
https://1drv.ms/u/s!AhsotbnGu1Nok2BRpqTKdCLHobHe
Regards,
Lydia
@clivebredenkamp,
Please check DAX in the following PBIX file.
https://1drv.ms/u/s!AhsotbnGu1Nok2BRpqTKdCLHobHe
Regards,
Lydia
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |