Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
HI,
Please help me to create a custom colum based on 3 other colums.
1. if patient type is OP then custom colum should reflect OP.
2. If patient type is only IP and Sponsor is only blank and Net amount less than 1000 then OP others as IP.
basically, the custom colum should reflect as the below.
Patient Type | Sponsor | Net Amt | Custom colum |
IP | Payer - Y | 490 | IP |
IP | 47 | OP | |
IP | 4200 | IP | |
OP | Payer - Y | 300 | OP |
OP | 25 | OP | |
OP | 2100 | OP |
Solved! Go to Solution.
Hi @Anonymous
Your net amount column is text please convert into interger / whole number.
select your net amount then convert to whole number.
Hi @Anonymous
You can try below calculated column.
I hope i answered your question!
Thank for your input.
But I am getting the below error. can you please help.
Hi @Anonymous
share your formula also...
bcz by looking at error wont able to understand you formula mistake.
Thanks in advance.
Hi @Anonymous
Your net amount column is text please convert into interger / whole number.
select your net amount then convert to whole number.
It worked. Thank you so much.
Hi @Anonymous
Did u take column right not measure???
Yes sir. Under Modeling - new column
Hi @Anonymous
error you are getting for type conversion it means your either of the column is text and comparing with numeric value<1000 or either of your column is numberi comparing with text value "OP" /"IP"..
Please check that..
I\
I hope it may resolved your issue!
Hi @Anonymous
You are basically there with how you outlined your reuqirements.
CustomColumn =
IF(Table[Patient Type] = "IP" &&
Table[Sponsor]= BLANK() &&
Table[Net Amt] < 1000, "OP",
IF(Table[Patient Type] = "OP", "OP", "IP")
Hope this helps
Joe
Proud to be a Super User! | |
Date tables help! Learn more
Thanks joe for your input. But i am getting the same error as below.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
70 | |
68 | |
43 | |
34 | |
26 |
User | Count |
---|---|
86 | |
49 | |
45 | |
38 | |
37 |