ROMAN

OK, I have held off posting this as part of my series on Excel to DAX Translation. The reason is that apparently the DAX code I used exposed a bug nested deep within the bowels of DAX. You can read a...

ROMAN.pbix139 KB

Other

Anonymous

Not applicable

4 years ago

Hi Greg,

many thanks for your quick measures.

Roman number is also a fine peice of code. But this approach can't be used in a real report like sales. Maybe it would be possible to extent it by the roman way of thousands?

Elementary Math Tricks (synonym.com)

How to write one million in Roman numerals - Quora

But I have no clue if it is possible to overline a character in DAX, some examples from wikipedia

IV = 4,000
IVDCXXVII = 4,627
XXV = 25,000
XXVCDLIX = 25,459

Many thanks for your work

Kind regards

Matthias

Greg_Deckler

Community Champion

4 years ago

Anonymous Not a lot of bar symbols available but there is an X bar UNICODE character: X Bar Symbol (x̄) (wumbo.net). There is also a reversed C character: Unicode Character 'LATIN SMALL LETTER REVERSED C' (U+2184) (fileformat.info).

So, in theory could add the appropriate notation to the conversion table for larger numbers.

Anonymous
Not applicable
4 years ago
There is a possibility to combine unicode characters

Roman_million = "M" & UNICHAR(772)

or

Roman_million = "M" & UNICHAR(773)