The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
hello everyone ,
i have a measure that says:
Previous Sales =
VAR TotalSales = CALCULATE(SUM(Revenue[Sales]),PREIOUSMONTH(Date[date]))
RETURN
"PV: " & TotalSales
The result i got is for example :
PV: 109765.67
my desired result is PV: $109,765.67
How can i add this to the measure please to get the result
Solved! Go to Solution.
You can use the FORMAT function, e.g.
Previous Sales =
VAR TotalSales = CALCULATE(SUM(Revenue[Sales]),PREIOUSMONTH(Date[date]))
RETURN
"PV: " & FORMAT(TotalSales, "Currency")
You can use the FORMAT function, e.g.
Previous Sales =
VAR TotalSales = CALCULATE(SUM(Revenue[Sales]),PREIOUSMONTH(Date[date]))
RETURN
"PV: " & FORMAT(TotalSales, "Currency")
thank you very much