https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Anonymous-Too/m-p/1106722#M533 <P>This is a better? implementation of my <A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Anonymous/m-p/552785" target="_self">Anonymous</A> quick measure. Well, it is at least more of what I originally envisioned when creating Anonymous. However it has an odd quirk that it is not 100% reversible like the original Anonymous quick measure. So, not sure if it is better because it is more obscure or worse becasue it is not reversible. Anyway, you can decide.&nbsp;</P> <P>&nbsp;</P> <P>And, in case you are interested, here is the reason it is not reversible and it is <A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/I-think-I-broke-DAX-again-bug-in-CONCATENATEX/td-p/1099936" target="_self">a "quirk" that I am not in any way happy about but apparently there is nothing to be done about it</A>.</P> <LI-CODE lang="markup">Anonymous Too = VAR __Value = MAX([Name]) VAR __Table = ADDCOLUMNS( ADDCOLUMNS( GENERATESERIES(1,LEN(__Value),1), "Char",MID(__Value,[Value],1) ), "Unicode",UNICODE([Char]) ) RETURN CONCATENATEX(__Table,[Unicode])</LI-CODE> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiODE3NjA2YjUtMmRmMC00Y2Q1LWE5ZDItMjQ0ZTkxNmJhMWUxIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Fri, 22 May 2020 17:55:05 GMT Greg_Deckler 2020-05-22T17:55:05Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Anonymous-Too/m-p/1106722#M533 <P>This is a better? implementation of my <A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Anonymous/m-p/552785" target="_self">Anonymous</A> quick measure. Well, it is at least more of what I originally envisioned when creating Anonymous. However it has an odd quirk that it is not 100% reversible like the original Anonymous quick measure. So, not sure if it is better because it is more obscure or worse becasue it is not reversible. Anyway, you can decide.&nbsp;</P> <P>&nbsp;</P> <P>And, in case you are interested, here is the reason it is not reversible and it is <A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/I-think-I-broke-DAX-again-bug-in-CONCATENATEX/td-p/1099936" target="_self">a "quirk" that I am not in any way happy about but apparently there is nothing to be done about it</A>.</P> <LI-CODE lang="markup">Anonymous Too = VAR __Value = MAX([Name]) VAR __Table = ADDCOLUMNS( ADDCOLUMNS( GENERATESERIES(1,LEN(__Value),1), "Char",MID(__Value,[Value],1) ), "Unicode",UNICODE([Char]) ) RETURN CONCATENATEX(__Table,[Unicode])</LI-CODE> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiODE3NjA2YjUtMmRmMC00Y2Q1LWE5ZDItMjQ0ZTkxNmJhMWUxIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Fri, 22 May 2020 17:55:05 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Anonymous-Too/m-p/1106722#M533 Greg_Deckler 2020-05-22T17:55:05Z