This seems like it should be easy, but I can't think of where to start. I have a value under the date of 01/01/1980. I want this value to duplicate across all future dates in the dataset. I don't want to do it in the backend because the data set is huge, so it creates 29 million rows. Is there a calculated field to spread this exact value across all data points consistently?
4 answers
you didn't ask about different locations in the question - you just said you had a value you wanted repeated across all dates - this would make it location dependent
{ FIXED [Location],[Product]: min(if [Date]= #1/1/1980# then [Max Inventory] end) } see https://jimdehner.com/2023/09/09/bgs-session-8-special-calculations-lods/ to better understand LODs
