****//Parámetro "StartDate" //*****

#date(2016, 1, 4) meta [IsParameterQuery=true, Type="Date", IsParameterQueryRequired=false]

****//Parámetro "FirstFY" //*****

2016 meta [IsParameterQuery=true, Type="Any", IsParameterQueryRequired=false]


****//Parámetro "NYears" //*****

5 meta [IsParameterQuery=true, Type="Number", IsParameterQueryRequired=false]


****//Tabla Calendario445 //*****

let
    NumeroDias=364*NYears,
    Source = List.Dates(StartDate,NumeroDias,#duration(1,0,0,0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type date}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Fecha"}}),
    #"Added Index" = Table.AddIndexColumn(#"Renamed Columns", "DayID", 1, 1),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Index",{{"DayID", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type1", "YearId", each Number.RoundDown(([DayID]-1)/364)+1, Int64.Type),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "QuarterId", each Number.RoundDown(([DayID]-1)/91)+1, Int64.Type),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "MonthId", each Number.RoundDown([DayID]/91)*3+
( if Number.Mod([DayID],91)=0 then 0
else if Number.Mod([DayID],91)<=28 then 1
else if Number.Mod([DayID],91)<=56 then 2
else 3), Int64.Type),
    #"Added Custom3" = Table.AddColumn(#"Added Custom2", "WeekId", each Number.RoundDown(([DayID]-1)/7)+1, Int64.Type),
    #"Added Custom4" = Table.AddColumn(#"Added Custom3", "FY", each FirstFY-1+[YearId], Int64.Type),
    #"Added Custom5" = Table.AddColumn(#"Added Custom4", "FYName", each "FY"&Text.From([FY]), type text),
    #"Added Custom6" = Table.AddColumn(#"Added Custom5", "FQ", each [QuarterId]-(4*([YearId]-1)),Int64.Type),
    #"Added Custom7" = Table.AddColumn(#"Added Custom6", "FQName", each [FYName]&"-"&"Q"&Text.From([FQ]), type text),
    #"Added Custom8" = Table.AddColumn(#"Added Custom7", "FM", each [MonthId]-(12*([YearId]-1)),Int64.Type),
    #"Added Conditional Column" = Table.AddColumn(#"Added Custom8", "FMMesNombre", each if [FM] = 1 then "JAN" else if [FM] = 2 then "FEB" else if [FM] = 3 then "MAR" else if [FM] = 4 then "APR" else if [FM] = 5 then "MAY" else if [FM] = 6 then "JUN" else if [FM] = 7 then "JUL" else if [FM] = 8 then "AUG" else if [FM] = 9 then "SEP" else if [FM] = 10 then "OCT" else if [FM] = 11 then "NOV" else if [FM] = 12 then "DEC" else null),
    #"Changed Type2" = Table.TransformColumnTypes(#"Added Conditional Column",{{"FMMesNombre", type text}}),
    #"Renamed Columns1" = Table.RenameColumns(#"Changed Type2",{{"FM", "FMNum"}}),
    #"Inserted Prefix" = Table.AddColumn(#"Renamed Columns1", "FMNumText", each "0" & Text.From([FMNum], "es-ES"), type text),
     #"Extracted Last Characters" = Table.TransformColumns(#"Inserted Prefix" , {{"FMNumText", each Text.End(_, 2), type text}}),
    #"Added Custom9" = Table.AddColumn(#"Extracted Last Characters", "FMEjercicioMes", each [FYName]&"-"&"M"&[FMNumText]),
    #"Changed Type3" = Table.TransformColumnTypes(#"Added Custom9",{{"FMEjercicioMes", type text}}),
    #"Added Custom10" = Table.AddColumn(#"Changed Type3", "FW", each [WeekId]-(52*([YearId]-1)),Int64.Type),
    #"Inserted Prefix1" = Table.AddColumn(#"Added Custom10", "Prefix", each "0" & Text.From([FW], "es-ES"), type text),
    #"Renamed Columns3" = Table.RenameColumns(#"Inserted Prefix1",{{"Prefix", "FWtext"}}),
    #"Extracted Last Characters1" = Table.TransformColumns(#"Renamed Columns3", {{"FWtext", each Text.End(_, 2), type text}}),
    #"Added Custom11" = Table.AddColumn(#"Extracted Last Characters1", "FWEjercicioSemana", each [FYName]&"-"&"W"&[FWtext],type text),
    #"Added Custom12" = Table.AddColumn(#"Added Custom11", "DayinYear", each [DayID]-(364*([YearId]-1)),Int64.Type)
in
    #"Added Custom12"