Forum Discussion
how to calculate SUM of Increase and decrease and summary of all
Hello I have a table with amonth of order for each item (F[Value]) and the date of order (conceted to DIMDATE Table) , I needed to calulated sum of orders in selected month and it's prior month , s...
I found answere:
I have used this for decreasing :SUMX(FILTER(ALLSELECTED('Forecasting Folder'[PartNo]),[Forecast Quantity Changed]<0),[Forecast Quantity Changed])and this one for increaseing : SUMX(FILTER(ALLSELECTED('Forecasting Folder'[PartNo]),[Forecast Quantity Changed]>0),[Forecast Quantity Changed])
Hello,
I also want to know answer about these question. I'm now occuring the same problem.
Thank you.
I found answere:
I have used this for decreasing :SUMX(FILTER(ALLSELECTED('Forecasting Folder'[PartNo]),[Forecast Quantity Changed]<0),[Forecast Quantity Changed])and this one for increaseing : SUMX(FILTER(ALLSELECTED('Forecasting Folder'[PartNo]),[Forecast Quantity Changed]>0),[Forecast Quantity Changed])Thank you so much. I'll try with your instruction.