Forum Discussion
CRM option set problem
I already found a solution that was actually quite simple...
Add a new formula column to the table with the option set value's and use the LOOKUPVALUE DAX formula in the table editior (not the query editor) mode and search for the gap_optionsetschema values. Next, add an extra search parameter to the formula so you can search on the field option set name AND the option set value and the right value will be filled in in this column.
You need to do this for each option set column, but it is quite simple and the quickest way to solve this problem.
I already found a solution that was actually quite simple...
Add a new formula column to the table with the option set value's and use the LOOKUPVALUE DAX formula in the table editior (not the query editor) mode and search for the gap_optionsetschema values. Next, add an extra search parameter to the formula so you can search on the field option set name AND the option set value and the right value will be filled in in this column.
You need to do this for each option set column, but it is quite simple and the quickest way to solve this problem.
Thanks for answering. Do you have an example?
