Forum Discussion
Generating monthly table with diminishing Object values on hardcoded predefined values
Hello all, My data contains alot of different object with yearly or monthly "contracts". These contracts represent the values of object on specific dates and whether the value deminishes on a pe...
amitchandak
Super User
Super UserMuffin92 , I did not get complete information. But this approach to create a new table can help
addcolumns(generate(Table, generateseries(0,4,1)), ("New Date" , Eomonth([Date], if([COntract] ="Monthly",([Value]*1)-1, ([Value]*12)-1) )+1) )
generateseries will decide the number of year or month
Thanks for the reply! Sadly i'm not able to get the output i'm looking for (screenshot 2 in post) with a value split between months since it's based on a single value. I can't make it work for multiple values (like object 1) or when the contract is different (yearly). Do you have some additional tips that could work with that?
Kind Regards, Muffin