Anonymous Too 05-22-2020 10:55 AM

[Greg_Deckler]

This is a better? implementation of my Anonymous 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. 

And, in case you are interested, here is the reason it is not reversible and it is a "quirk" that I am not in any way happy about but apparently there is nothing to be done about it.

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])

eyJrIjoiODE3NjA2YjUtMmRmMC00Y2Q1LWE5ZDItMjQ0ZTkxNmJhMWUxIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9