Forum Discussion
SUMX wrong totals
HI when I export data, totals are different to what i am getting in Power bi dashboard please help me with the following problem. I have customer, material , segmant, sales, quantitiy all the fiel...
my table values are customer no, material no, sales amount, Quantity ,year month.
calculation require :
if the sales current year or sales previous year sales is nill then 0 if not
==sales per unit variance( current sales /quantity - previous year sales /quantity) * quantity cy