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.
For your dataset, I'd re-model it by "unpivot" first and then do a "merge". Check more details in the attached pbix.
By the way, posting sample data as plain text is prefred as it is time saving. :)
Eric_Zhang thanks for your option, but this dod not work on my dataset. Really appreciating your help!!
Because I think your understanding might be much easier with sample data, i have added an excel and .pbix sample file to show what i would like to do.
Now in the table, Opportunities, i like to replace the value rows with the gap_label rows with the same value from the Optionset table.
This is an example, the number of columns and the number op different fields an optionset can increase.
Hope you can help me with this :
Can't attach file so here it is: https://ufile.io/4ed7c
Anyone an idea based on the example file that was posted?