Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
In my master table (Claim Data Pull) there is a field named (Total Paid). I would like to create a column in that table that specifies whether or not the Total Paid amount qualifies as a "High Cost Claim", a "Medium Cost Claim", or "Neither High or Medium Cost Claim".
1) A "High Cost Claim": Greater than or equal to $50,000
2) A "Medium Cost Claim": Is Greater Than or Equal to $25,000 and less than $50,000
I tried creating / using a 'Conditional Column' but you can't specify inbetween ranges.
Please help. Thank you.
Solved! Go to Solution.
Add a custom column in query editor and paste this.
=if [Total Paid] >= "50000" then "High Cost Claim" else if [Total Paid] >= "25000" and [Total Paid] < "50000" then "Medium Cost Claim" else "Neither High or Medium Cost Claim"
If this helps, mark it as a solution
Kudos are nice too
Add a custom column in query editor and paste this.
=if [Total Paid] >= "50000" then "High Cost Claim" else if [Total Paid] >= "25000" and [Total Paid] < "50000" then "Medium Cost Claim" else "Neither High or Medium Cost Claim"
If this helps, mark it as a solution
Kudos are nice too
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |