Forum Discussion
Need Help with formatting
I am building my first Power BI sheet and struggling on one thing. I had to convert my Money calculations to text to get them to enter into my circles and now i cannot format them to show as money.
An example of my new field is:
AdjustmentsText = "" & 'Extract PowerBI_RCMFinancials'[TotalAdjustments]
3 Replies
- amitchandak
Super User
I am getting a syntax error, can you point me to where i have this incorrect?
AdjustmentsText = "" & 'Extract PowerBI_RCMFinancials'format([TotalAdjustments],"#,###.00")
- VahidDM
You used it in the wrong way, try this as amitchandak mentioned:
AdjustmentsText = format('Extract PowerBI_RCMFinancials'[TotalAdjustments],"#,###.00")
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
