Auto Units using DAX Format
In several Power BI reports, I need to concatenate numbers with string using DAX to make a insightful statement. While doing so, I observed that the numbers cannot be formatted to Auto Units using a single Format_String in FORMAT() such that they can be displayed as 5K, 10M, 20B, 1,023, 1, 99 etc. based on the filters selected.
Please add a new Format_String for FORMAT() in DAX that can be used to populate numbers in Auto Units format.