Forum Discussion
JSturgeon
4 years agoNew Member
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. ...
JSturgeon
4 years agoNew Member
I am getting a syntax error, can you point me to where i have this incorrect?
AdjustmentsText = "" & 'Extract PowerBI_RCMFinancials'format([TotalAdjustments],"#,###.00")
- VahidDM4 years ago
Super User
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✌️!!