Add a fix number to sum formula in PBI

[mohiniverma2704]

Hi Team, 

I am trying to add a number to a measure in PBI

Measure : 

Approved Total_Formatted = FORMAT (

    SUM ( 'Tracker'[XXX])

        + SUM ( 'Tracker'[YYY]),

    "$#,##0;($#,##0)"

)

This is the formula, now I need to add fix amount of "$7,500" to the above result. How can I do that?

[Idrissshatila · Accepted solution]

Hello @mohiniverma2704 ,

try the following

Approved Total_Formatted = FORMAT (
   (SUM ( 'Tracker'[XXX])
        + SUM ( 'Tracker'[YYY]))+ 7500,
    "$#,##0;($#,##0)"
)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Ritaf1983 · Accepted solution]

Hi @mohiniverma2704 
If i understood you correctly you can use :

Approved Total_Formatted = FORMAT (

    SUM ( 'Tracker'[XXX])

        + SUM ( 'Tracker'[YYY]),

    "$#,##0;($#,##0)"

) & unichar(10)& "$7,500"
if not please show de desired result

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Idrissshatila · Accepted solution]

Hello @mohiniverma2704 ,

try the following

Approved Total_Formatted = FORMAT (
   (SUM ( 'Tracker'[XXX])
        + SUM ( 'Tracker'[YYY]))+ 7500,
    "$#,##0;($#,##0)"
)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡