Forum Discussion
Multiple concatenated columns - Best practice
Hi Anonymous ,
Yes, I think it should suitable for your requirement. For extract original fields values, you can refer to following dax formula:
Test = PATHITEM(SUBSTITUTE([Column],"-","|"),1)
Notice: Bold part is position of merged string, you can modify to different number to extract correspond fields value.
Regards,
Xiaoxin Sheng
Hi Anonymous ,
You can consider to add new column to store merged key values in query editor side, then remove original fields to reduce data structure complexity.
For original key fields, you can simply extract them based on separator.
Regards,
Xiaoxin Sheng
Hi!
So, if i correctly understood, you are proposing:
- to create a column with the most detailed key i need. In the example then A-11-34-12
- if possible remove the columns that were base for that key
- if i need only a part of the key, e.g. the first 3 postions, then extract it in DAX
For example with a formula like calculate(distinctcount(mid(...
I am right?
Best regards. G.
Hi Anonymous ,
Yes, I think it should suitable for your requirement. For extract original fields values, you can refer to following dax formula:
Test = PATHITEM(SUBSTITUTE([Column],"-","|"),1)
Notice: Bold part is position of merged string, you can modify to different number to extract correspond fields value.
Regards,
Xiaoxin Sheng
Thanks Anonymous !
I will try it in my next project.
Cheers. G