Can I set calendar sort columns once and import to multiple models.

[Anonymous]

Hi , if i import a calendar table to a power bi. I than have to associate a sort column to say text like Jan , Feb , Mar etc.

The data is all there in the data I import, but the sort by association needs to be made. Do I need to do this in every model - or is there a track I am missing, so I set it once and each model its imported to knows teh sort by associations?

Thanks

[amitchandak · Accepted solution]

@Anonymous , As of now Power BI only allows the copy of the table from Data Transformation/ edit Query Tab. This means the Date table created using Dax can not be a copy-pasted from one model to another.

The way as now is have pbix with Date table, always start the project using a copy of that.

Semantic Data Model has been discussed in May 2020, Business Submit will be available in some time that will allow merging models, there date table can be one model.

[Anonymous]

Thanks , good to see something like that may be on the way. Thanks  , For calendar yes I can just start with that in my pbix. Thanks.