Reference date aware/time filters
To filter on data data is relevant today, you need to fill in a begin date/end date.
 | This topic is about Planon reference data aware BOs (for example: Space usages, Accounts). Note that this excludes lifecycle aware BOs such as Contracts (these are treated differently). |
Typically, Planon leaves the end date empty.
Fill the end date with a date in the future: in the data model view (3) you add a column with this functionEnddate replace empty values
= Replacer.ReplaceValue(Logical.From([EndDate]),null, Date.AddYears(DateTime.LocalNow(), 50))
Now you can filter on values between begin date and end date.
| | PowerBI also features a lot of relative date filters built in which you can use. |