Forum Discussion
If Condition for Text not Working
- Such things should be done in Power Query (M), not in DAX. Use the right tool for the job. On top of that, M code would be very simple. No messing around with context and context transition.
DAX is a Data Analysis eXpressions language, not data mash-up language. M is.
Best
D. Hi there.
Again, this is not the way to do it. First, you should create an auxiliary table that will hold all the mappings from status to classification. Then, in PQ, you left outer join the target table to the mappings table and get the column you need.
This procedure makes sure you don't have to go back to the M code when you need to change a mapping or add a new one. All you have to do is manage the mappings which can be done in the source through SQL (if your data comes from a relational database).
Best
D.
I would try to accomplish this with a measure using a switch statement such as:
status = switch([status],
Retired, "Closed"
Submission Declined, "Closed"
Closed with Feedback, "Closed"
assigned,"Open"
etc...
)
If you wanted to stick with an IF statement it would have to be nested such as:
IF([status] = "retired","Closed",(IF([status] = "Submission Declined","Closed",(IF([status] ="assigned","open",(IF etc.. )))
but that could get long and messy which is why i recomend the switch statement above
So I tested this out for a few of the status...
switch(Table1[Status],"Retired", "Closed", "Submission Declined", "Closed", "Assigned", "Open").This resulted the entire column going to blank. Did I type this in incorrectly or do I have to fill out all of the 7 status for it to work?- Such things should be done in Power Query (M), not in DAX. Use the right tool for the job. On top of that, M code would be very simple. No messing around with context and context transition.
DAX is a Data Analysis eXpressions language, not data mash-up language. M is.
Best
D.
Anonymous wrote:
Such things should be done in Power Query (M), not in DAX. Use the right tool for the job. On top of that, M code would be very simple. No messing around with context and context transition.
DAX is a Data Analysis eXpressions language, not data mash-up language. M is.
Best
D.Anonymous Thanks for pointing this out. I was not aware of the two langauges.
I was able to use the Replace Value function on the Column inside the Advanced Editor and now it works.
#"Replaced Value" = Table.ReplaceValue(#"Duplicated Column","Work In Progress","Open",Replacer.ReplaceText,{"Status - Copy"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","Pending Expert","Open",Replacer.ReplaceText,{"Status - Copy"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","Assigned","Open",Replacer.ReplaceText,{"Status - Copy"}),
#"Replaced Value3" = Table.ReplaceValue(#"Replaced Value2","Pending Submitter Information","Open",Replacer.ReplaceText,{"Status - Copy"}), ..... etc