📄️ Format strings
Formatstrings are a way to show measures in certain way, without touching the underlying data. Formatstrings are able to do lot of things, but can get complex as well. That's why it is possible to use custom format strings in Easy Tabular with recognizable names. In formatstrings.yaml file the format string can be defined as follows:
📄️ Derived Measure
Derived measures is a special method to easily create complex measures based on existing measures. It's called Derived Measure. It is meant to be used for measures that are very similar and are related to a main measure. Like YTD, PY and also custom variants that can be defined by you and your specific wishes. In other solutions, you are forced to use all kind of obscure C# scripts, not with derived measures. It works as follows:
📄️ Roles
In Roles.yaml we define the roles that can be used in the model.yaml. To add users to a role, just define them in the roles.yaml. Since this can be quite a long list of users, it's most advisable to have Entra-groups where those people can be added and that roles.yaml only contains that Entra-group.
📄️ Derived Model
📄️ Partitioning
Tables can become quite big in a Tabular model, when it is getting too big, it is possible to split the table into multiple partitions. A table always has at least one partition. Partitioning just means splitting the table in multiple parts. From the users perspective it still looks like one big table. There are multiple possibilities to set up partitioning.