Forum Discussion
Solved
Need help optimizing Filters in Calculation
Hello, I'm having an issue with performance with one of my Calculated Columns. I have a table similar to example below with more than 6 million rows. I am trying to make a column that count ...
Hi Adak,
could you try this column code out, unfortunately I can't test it myself but it should use a lot less memory and do what you want:
Total Qty =
SUMX (
FILTER (
FILTER (
Inventtrans;
Inventtrans[ItemWithOrderID] = EARLIER ( Inventtrans[ItemWithOrderID] )
);
Inventtrans[TransactionDate] <= EARLIER ( Inventtrans[TransactionDate] )
);
Inventtrans[Qty]
)Sorry for interrupting if your problem has already been fixed by Xiaoxin Sheng.
Best regards
Oxenskiold.
Hi Anonymous
I'm not sure I understood this correctly, that field already includes some letters so it doesn't allow me to convert that columnt to whole number
Error: Cannot convert value 'Hammer1' of type Text to type Integer.