Forum Discussion

PSRai's avatar
PSRai
Icon for Helper III rankHelper III
7 years ago

Formulas

HI All,    I'm fairly new to PowerBI and Im struggling to get a formula to work, Im hoping one of you experts can help me    IF(SUM('Order Data'[DocumentTypeID])=1,(SOPInvoiceCreditLine[LineTota...
Need Help
PSRai's avatar
PSRai
Icon for Helper III rankHelper III
7 years ago

Hi

 

Thanks, I have tried that but still not working, 

Their is a minus figure applied to all figures instead of the one with the condition.

 

See diagram below. 

 

So the very last figure should be a negative also the figures in Line Val ADJ should match those in LineTotalValue

 

Hope you can help 

 

Line Val ADJ

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

What's the relationship between 'Order Data' and 'SOPInvoiceCreditLine' can you post a picture of the table diagram?

 

Is [LineTotalValue] a measure or a column?