Forum Discussion
How to compute Sales X Sign ?
Hi All
My Raw data :-
Sign = 2 mean -ve value , so 20*-1=20
Expected Result , see yellow column :-
my PBI file :-
https://www.dropbox.com/s/108h3rh4v0443z6/compute%20amount%20with%20sign%20v001.pbix?dl=0
Anonymous , please find the file attached after signature
7 Replies
Anonymous , please find the file attached after signature
Anonymous , try
A new colum
if([sign]=2, -1*[sales], [sales])
A new measure
sumx(Table,if([sign]=2, -1*[sales], [sales]))
Anonymous , there is ; in the second name in else part