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.
Good afternoon all,
I have a table containing a field called 'Description', and a field called 'Amount'. I would like to create a field that displays the amount if the description field contains the substring 'dividend'. The appearance of this substring can appear anywhere in the description field. I believe I need to use 'Text.Contains' but have been unsuccessful in the syntax usage.
Any and all help is greatly appreciated.
Jim
Solved! Go to Solution.
Hi @JimB-GA
There's a very simple way to do it.
You can add a conditional column in edit query.
= Table.AddColumn(#"Promoted Headers", "Custom", each if Text.Contains([Description], "dividend") then [Amount] else [Description])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @JimB-GA
There's a very simple way to do it.
You can add a conditional column in edit query.
= Table.AddColumn(#"Promoted Headers", "Custom", each if Text.Contains([Description], "dividend") then [Amount] else [Description])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks. A quick and easy solution.
Jim
HI @JimB-GA ,
calculated column:
Hi @JimB-GA
there are 2 different entities:
1. Power Query mode. it work with data source and uses M language. in this mode 'Text.Contains' should be ok
2. DAX mode. This is the mode to create visuals and add business logic to your report. If you want to use this mode you should look at SEARCH (https://docs.microsoft.com/en-us/dax/search-function-dax) or FIND (https://docs.microsoft.com/en-us/dax/find-function-dax) functions
do not hesitate to give a kudo to useful posts and mark solutions as solution
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |