Hi,Does anyone knows how to get the first date of the model?*The first date that comes from the time dimensionI want to compare the first date of the model against date input by user.
@weilun.wong
If you are looking at the first date of the month you can directly use START() function to get the same, if the module is time dimensioned.
If you want to get the first date of the model calendar, set the summary of the above Date line item to 'Min'
Now create one more module and write the mentioned formula
First Date.Date[SELECT: TIME.All Periods]
I hope it helps
~Anand
Hi Anand,Thanks for your solution, it works well.
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
Why in my model output is blank, after send explainability data.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
