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.
I want have the operator used in a custom column be based on the data in another field but keep getting an error.
For example, my dataset has the following fields
Field A (The DataPoint) Field B (The Measurement Type) Field C- (The Threshold)
3 > 1
I want to write a custom column formula that says:
If [Field A] [Field B] [Field C] then 1 else 0
The formula works if i type in > instead of using [Field B], however, some rows use another operator (like = or <). Is there a way to write the formula with the operator being [Field B]?
Solved! Go to Solution.
Hi @hatcher78
But I have another idea how you can to it:
Measure =
SWITCH(
SELECTEDVALUE([FieldB]),
">", IF([FieldA]>[FieldC],1,0),
"<", IF([FieldA]<[FieldC],1,0),
">=", IF([FieldA]>=[FieldC],1,0),
"<=", IF([FieldA]<=[FieldC],1,0)
)
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hi @hatcher78
I really have never seen this anytime in any report so I would say it is not possible to transform a text field into an operator.
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hi @hatcher78
But I have another idea how you can to it:
Measure =
SWITCH(
SELECTEDVALUE([FieldB]),
">", IF([FieldA]>[FieldC],1,0),
"<", IF([FieldA]<[FieldC],1,0),
">=", IF([FieldA]>=[FieldC],1,0),
"<=", IF([FieldA]<=[FieldC],1,0)
)
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |