The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I am searching for help with this unique example.
I have in my dataset column with comparison sign.
Is it possible to compare Value and use sing from the column? I want to create one column with a flag if Value is in the specification
In the first example, 0 is in spec because it is below 20
In the second example, 1 is not equal to 0 and it is not
I really appreciate any help you can provide.
Solved! Go to Solution.
Hi @kosa_seba ,
You would have to do this using a conditional column that defines what the text representation of the operator (Sign) means, and apply it to an appropriate calculation.
For example, your conditional column would have to be built something like this:
if [Sign] = "<" and [Value] < [SingValue] then "In Spec"
else if [Sign] = ">" and [Value] > [SingValue] then "In Spec"
else if [Sign] = "=" and [Value] = [SingValue] then "In Spec"
...
...
else // your escape value e.g. "Not In Spec", null etc.
Pete
Proud to be a Datanaut!
Thank you very much, Pete. It works well.
Hi @kosa_seba ,
You would have to do this using a conditional column that defines what the text representation of the operator (Sign) means, and apply it to an appropriate calculation.
For example, your conditional column would have to be built something like this:
if [Sign] = "<" and [Value] < [SingValue] then "In Spec"
else if [Sign] = ">" and [Value] > [SingValue] then "In Spec"
else if [Sign] = "=" and [Value] = [SingValue] then "In Spec"
...
...
else // your escape value e.g. "Not In Spec", null etc.
Pete
Proud to be a Datanaut!