I’m trying to have a button that could automatically create rows based on the values already existing in my table.
I have two tables,
One with raw data and one where i want aggregated data.
What I want for my button to do is to create a row in the aggregated data only if the line doesn’t exist yet.
I came up with this sort of formula :
[RawData].FormulaMap( WithName( currentValue, currentRawData, If( [AggregatedData].Filter(Month = currentRawData.Month).Count() > 0 , "" , AddRow( [AggregatedData], [AggregatedData].Month, currentRawData.Month ) ) ) )
If my table is empty and I have 3 values in the rawData, it will create three times the same raw. I guess there’s something like when creating the raw, it is not reflected in the running function.
But I don’t know how I could do this instead !
If anyoone has an advice ! happy to hear it