cancel
Showing results for 
Search instead for 
Did you mean: 

Anonymous Too

Super User IV
215 Views
Highlighted
Super User IV
Super User IV

Anonymous Too

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

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!