Forum Discussion
Replace Dynamics D365 StateCode by values
Hi Anonymous,
Create one dimension table based on unique records from all related table columns and build relationships obviously will affect performance.
If you can direct modify source data, it should more quickly than my suggestion.
If you mean do replace operation on power query side, it should complex and low performance.(you need to create a dictionary table to compare and replace state on all of tables who contains state column)
Regards,
Xiaoxin Sheng
HI Anonymous,
I'd like to suggest you create a status table with state code and description, build relationships from this table to all of statuscode columns.
After this step, you can use 'description' column to replace status code column on visualization to display more clearly status description.
Regards,
XIaoxin Sheng
Hi Anonymous
Thanks a lot for your reply.
That is a good idea, but I'm worried about performance, and I'm wondering if replacing the values directly in the table would make calculations faster ?
What do you think ?
Thank you.
Thomas.
Hi Anonymous,
Create one dimension table based on unique records from all related table columns and build relationships obviously will affect performance.
If you can direct modify source data, it should more quickly than my suggestion.
If you mean do replace operation on power query side, it should complex and low performance.(you need to create a dictionary table to compare and replace state on all of tables who contains state column)
Regards,
Xiaoxin Sheng