Forum Discussion
Display minimum value on every row under group
Since making this calculation off the measures I already have doesn't work, I decided to create a new table in my DB then create calculated columns to get the answers I needed. Not ideal, but it works.
Thanks everyone for your input.
I should have mentioned that these are all measures. The table is too large to handle calculated columns (approx. 4M rows).
Also the SKU is not listed on the current table and will not populate under the EARLIER() functions (I don't actually know it won't populate). Otherwise this would probably work.
I'm not sure how to do this if these are all measures.
1] Assuming you can create a dynamic table with the fields SKU, Size, etc.
I have created a normal data table from data file for demo.
2] I created a measure on this table for the NewSize%
3] Dynamically create another table using the table in step#1 and added a new column for Minimum Size%
I understand still the 4M rows performance impact will apply, but putting this forward as a thought.
Hope this helps.
Since making this calculation off the measures I already have doesn't work, I decided to create a new table in my DB then create calculated columns to get the answers I needed. Not ideal, but it works.
Thanks everyone for your input.