Table aliassing experiance

[jaccodezwart72]

Hi all,

Does anybody has experiance with table aliassing using Calculated Tables in your model ?

For example, when you have a Date table (with several date specific columns) and you want to re-use the whole table in an other perspective using an other name. Something like OrderDate, DeliveryDate and relate those date columns to an aliased table for their specific purpose.

Hope my question is clear.

Thanks,

Jacco

[otykier]

Hi @jaccodezwart72
I'm afraid what you're asking is not possible in Power BI / SSAS semantic models. You could experiment a bit with using metadata translations (i.e. keep one set of translations for every perspective, in which you specify "OrderDate", "DeliveryDate", etc. as the translated name of the table. Users would then connect to the model with a specific perspective AND LocaleIdentifier). This works in theory, but there are some side effects, like error messages being shown in other languages, etc.

A more practical approach is just to have additional copies of the table in your model, and then show the right one based on the selected perspective. For small dimension / date tables, that usually only take up a few KB in memory, this is not a problem. Keeping them in sync, i.e. if you add additional columns to one, you want those columns to be added to all, is more tricky, but Tabular Editor's copy/paste feature can help.