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.
Hello guys,
I would like to replace the "63" value in the TT_ACT_ID column if the project number is "168907" in column TT_PRJ_ID.
I have used replaced value with a if formula but it doesn't work. I've tried a couple of dax formula, see below.
The formula I've used are:
= Table.ReplaceValue(#"Renamed Columns",
63,
each if [TT_PRJ_ID]= "168907" then "13" else [TT_ACT_ID] ,
Replacer.ReplaceValue,{"TT_ACT_ID"})
= Table.ReplaceValue(#"Renamed Columns",
each [TT_ACT_ID],
each if [TT_PRJ_ID]= "168907" and [TT_ACT_ID]= "63" then "13" else [TT_ACT_ID] ,
Replacer.ReplaceValue,{"TT_ACT_ID"})
Thanks guys!
Greetings,
Ka-Lok
Solved! Go to Solution.
Hi,
Your data format in [TT_PRJ_ID] is INT so by remowing "" in your condition ([TT_PRJ_ID]=168907 ) you should be good to go.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi,
Your data format in [TT_PRJ_ID] is INT so by remowing "" in your condition ([TT_PRJ_ID]=168907 ) you should be good to go.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |