Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
netanel
Post Prodigy
Post Prodigy

Finance Report

Hello everyone,
I have one Amount column and it brings me all the numbers to the reports, the problem is that the numbers come in minus 500 instead of (500).

I know this is a common problem but in all the solutions I didn't find anything to fix it .

 


עזרה 1.PNGעזרה 2.PNG








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki
1 ACCEPTED SOLUTION

Great, then we are halfway to the answer 🙂
It probably doesn't work because you are putting a column in the place of a Measure. 
I think you should make a measure as Total Amount = SUM(Amount), and then use that measure in this Formating. 

 

Measure = FORMAT(Total Amount,"#,###0;(#,###0)")

or you can make this all in one measure with a variable :
Measure =
var Total Amount = SUM(Amount)
return FORMAT(Total Amount,"#,###0;(#,###0)")

View solution in original post

4 REPLIES 4
MaxNovak
Resolver I
Resolver I

Hi,
I'm not completely sure about the question. If I understand you correctly you 
want to format the Amount, if it is negative to put Amount into brackets. 

If this is correct just make a measure like this :

FORMAT(Amount,"#,###0;(#,###0)")

You got me right, but it's a solution I've already tried and it doesn't work for me, this is the message I getעזרה 3.PNG

 

עזרה 4.PNG

 








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki

Great, then we are halfway to the answer 🙂
It probably doesn't work because you are putting a column in the place of a Measure. 
I think you should make a measure as Total Amount = SUM(Amount), and then use that measure in this Formating. 

 

Measure = FORMAT(Total Amount,"#,###0;(#,###0)")

or you can make this all in one measure with a variable :
Measure =
var Total Amount = SUM(Amount)
return FORMAT(Total Amount,"#,###0;(#,###0)")

Many thanks for the time and greatly appreciate it








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.