79474115

Date: 2025-02-27 23:02:07
Score: 2.5
Natty:
Report link

I did this recently. Here's my DAX (as a Measure): RevenueLabel = VAR Rev = SUM('All Sales'[Revenue]) RETURN IF(Rev >= 1000000000, FORMAT(Rev / 1000000000, "0.0") & "bn", FORMAT(Rev / 1000000, "0") & "m" )

Added New Measure; Included an IF() as I was using both "bn" and "m"

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Filler text (0.5): 000000000
  • Filler text (0): 000000000
  • Low reputation (1):
Posted by: Shannon Mieloch