Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 @Prasanthh60
Your net amount column is text please convert into interger / whole number.
select your net amount then convert to whole number.
Hi @Prasanthh60
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 @Prasanthh60
share your formula also...
bcz by looking at error wont able to understand you formula mistake.
Thanks in advance.
Hi @Prasanthh60
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 @Prasanthh60
Did u take column right not measure???
Yes sir. Under Modeling - new column
Hi @Prasanthh60
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 @Prasanthh60
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
86 | |
67 | |
49 |
User | Count |
---|---|
134 | |
113 | |
100 | |
68 | |
67 |