Create custom non-date table using Bravo

[a-v-gordon]

Hi there,

Pretty much every metric I use in any of my models has a budget, actual and forecast value. I'd like to create 3x entries in my time intelligence template for each selected measure, one for budget, one for actual and one for forecast.

To do this in Power BI, I would typically create a dimension table that listed the three possible data types, create a relationship to the relevant columns in each of my fact tables, and then filter on the dimension table in my measures.

Is it possible to create this dimension table using bravo, so that I can automate the creation of all three time intelligence measures rather than having to create three measures in my model and then running the time intelligence on all three of them?

[albertospelta]

Currently, Bravo templates only support creating calendar and holiday tables. It’s not yet possible to use them to create custom non-date tables and relationships. That said, this could be a useful improvement, and we’ll consider it for a future enhancement. Thanks!

[a-v-gordon]

That's good to know - thanks!

As an alternative, can an existing table in the model be referenced in a template? Creating a single table with a single column and then referencing that in my template is still far less hassle than creating all three measures individually every time I have a new dataset.

[albertospelta]

Yes, that’s possible. The custom template can reference existing tables in your model. So if you have a single-column table (e.g., for Budget / Actual / Forecast), you can use it in the DAX expression of your Time Intelligence measures.