How to Copy Master Calendar from another PBI file to my new AR Doc ?

[Paulyeo11]

Hi

[v-jayw-msft · Accepted solution]

Hi @Paulyeo11 ,

If i understand you correctly, you could click Transform data to open Query Editor, then find the queries under advance editor.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview#advanced-editor 

Best Regards,

Jay

[amitchandak]

@Paulyeo11 , You can copy the Power Query Script table. Not Dax script tables as of now.

You can save a pbix with a date table and use it.

Or best you create a calendar table using Addcolumns like

Date = ADDCOLUMNS(CALENDAR(date(2018,01,01),date(2020,12,31)) ,"Month Year", FORMAT([Date],"mmm-yyyy") ,"Month Year sort", FORMAT([Date],"yyyymm") ,"Year" , year([Date]))

You can easily copy paste table from one place to another