Hi all!
I'm trying to define the expression to calculate different KPIs. The problem I'm having is that I get data updates the 15th day (aprox.) of each month from the actual month performance. Today, June 3rd I have data from May (id is 05), and the 15th of June I will have data updated from the actual current month (id is 06).
I need the ids for each month to filter which information to use. How can I define the KPIs in order to choose the id depending on which is the most recent month from which information is available?
If I didn't make myself clear, feel free to ask anything you might find relevant and I'll try to make my problem more comprehensible.
Thank you very much in advance!
Laura