Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
H there,
I want to do a simple calculation which seems to be pretty easy in Excel but i dont get the solutions in PBI.
I have column A which has names in it.
The value in Column B and C should be added in Column D, if the text column A contains "ing" or "fy". Otherwise only the value in column B shoud be taken.
Thats an example how my data an column D should look like
A B C D
testing 1 1 2
testfy 1 1 2
test 1 3 1
testfying 1 2 3
Thanks
Carina
Solved! Go to Solution.
Hi @CesiCash,
Based on my test, you could refer to below steps:
Sample data:
Create the calculated column:
Column = var a=IF(IFERROR(SEARCH("ing",[A]),BLANK())<>BLANK(),TRUE(),FALSE())||IF(IFERROR(SEARCH("fy",[A]),BLANK())<>BLANK(),TRUE(),FALSE()) return IF(a=TRUE(),[B]+[C],[B])
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @CesiCash,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @CesiCash,
Based on my test, you could refer to below steps:
Sample data:
Create the calculated column:
Column = var a=IF(IFERROR(SEARCH("ing",[A]),BLANK())<>BLANK(),TRUE(),FALSE())||IF(IFERROR(SEARCH("fy",[A]),BLANK())<>BLANK(),TRUE(),FALSE()) return IF(a=TRUE(),[B]+[C],[B])
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi,
Try this function in Caluclated Column
if Text.Contains([A], "ing") or Text.Contains([A], "fy") then [B]+[C] else [B]
Unfortunately there is no text.contains function in powerbi?
Is there any other idea?
Best
Carina
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |