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,
Complete newbie in Power BI here, so please bear with me. Many thanks in advance!!!
What I am trying to achieve? determine the donor status based on 2 criterias: A donor is inactive
To note:
How I proceeded?
My issue:
Considering that a donor can have donated on multiple dates, for a given donor I end up with a given donor being active AND inactive (see screenshot below).
My question:
How can I apply the donor status for all the rows of a given donor?
Solved! Go to Solution.
Hi , @zakaria_chahbar
Here are the steps you can refer to :
(1)This is my test data :
(2)You can create a calculated column :
Donor_Status = var _current_id='amount_donated_last_date'[donorID]
var _current_date = 'amount_donated_last_date'[date]
var _sum =SUMX(FILTER('amount_donated_last_date','amount_donated_last_date'[donorID]=_current_id && amount_donated_last_date[date] = _current_date),[Total])
return
IF(YEAR('amount_donated_last_date'[date]) >2012 && _sum >5 , "Active","Inactive")
(3)Then we can meet your need , the result is as follows:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Try to add the new column with the code below:
Thanks a lot for your contribution!
It doesn't seem to be working unfornutaly. For donorID 100005 yes, but not for 100003 as you can see on the screenshots below. 100003 should be inactive (all donations in 2013 are below 5 USD).
aha, you wanna check the max donation, try this:
Hi , @zakaria_chahbar
Here are the steps you can refer to :
(1)This is my test data :
(2)You can create a calculated column :
Donor_Status = var _current_id='amount_donated_last_date'[donorID]
var _current_date = 'amount_donated_last_date'[date]
var _sum =SUMX(FILTER('amount_donated_last_date','amount_donated_last_date'[donorID]=_current_id && amount_donated_last_date[date] = _current_date),[Total])
return
IF(YEAR('amount_donated_last_date'[date]) >2012 && _sum >5 , "Active","Inactive")
(3)Then we can meet your need , the result is as follows:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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 |
---|---|
107 | |
100 | |
85 | |
77 | |
66 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |