I link to a data source which give me monthly updated data from SAP.
The problem is, that these data are uploaded every 10th of a giving month, and last month of updated data are either 1 or 2 month older than present month (depending of the present date).
Since I use the 'Relative Date' filter function in all my reports, I would like the ability, to set 'is in the last 12 month' to a parallel 12 month period based on any giving present date.
I upload a table with only one variable which gives me, the 'Latest data period' for the data set I link to - together with my data sets, so that could be part of the solution ?
Example:
Today (May 4th) my dataset has data up till March. So I would like Power BI to filter my data based on the last 12 month up till March, witch mean - April till March - even though the present date is in May.
Can anyone guide me ?
Thanks