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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

0

POWER BI NEGATIVE TO POSITIVE NUMBER CHANGE AND SUM

Hi Guys,

I saw the Answer on how to convert negative to positive values and I did it ! Now I have new column with positive values ( which are Ex negative values)

Now I try to use formula SUM to sum up the values, no error in measure. But when I put the measure in Visual, it shows blank. 

I already corrected the Data type: Decimal Number (which is true) and Format: Currency, and Summarization: SUM

Nothing helps. Please help!

Status: Delivered

Hi @KaviKumaran ,

 

I did some testing and it seems to work fine. If you convert differently than I do, consider trying to implement it this way.

vtianyichmsft_0-1701308012870.png

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

Comments
v-tianyich-msft
Community Support
Status changed to: Delivered

Hi @KaviKumaran ,

 

I did some testing and it seems to work fine. If you convert differently than I do, consider trying to implement it this way.

vtianyichmsft_0-1701308012870.png

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang