{"name":"ConsolidacionFechas","description":"","version":"1.0","culture":"es-ES","modifiedTime":"2020-11-14T13:11:59.230762+00:00","pbi:mashup":{"fastCombine":true,"allowNativeQueries":false,"queriesMetadata":{"FechaInicio":{"queryId":"3715ec78-3ac6-468b-a711-84842734f8ed","queryName":"FechaInicio","queryGroupId":"e5788d00-b118-4f36-8c24-0f497892395b"},"FechaFin":{"queryId":"b7148281-1cfd-4b33-948b-a79449794755","queryName":"FechaFin","queryGroupId":"e5788d00-b118-4f36-8c24-0f497892395b"},"NDias":{"queryId":"5970b83b-7ab5-4cee-b86b-ffcb4e3e4d19","queryName":"NDias","queryGroupId":"e5788d00-b118-4f36-8c24-0f497892395b"},"dimFechas":{"queryId":"328a84e8-5fa7-40f0-a4ba-98591ec42ddd","queryName":"dimFechas","queryGroupId":"3f38ade1-b5cf-40c8-aaa9-0cd226df948e","loadEnabled":true},"dimPeriodo":{"queryId":"696c5129-612f-4f48-b0cb-f383cfa80559","queryName":"dimPeriodo","queryGroupId":"3f38ade1-b5cf-40c8-aaa9-0cd226df948e","loadEnabled":true},"CreatePeriodTable":{"queryId":"2513f969-7d86-43e3-b0df-9de0f749885c","queryName":"CreatePeriodTable","queryGroupId":"844b4c37-ac10-4a19-bc71-22006bddf0d3"},"dimTiempo_minuto":{"queryId":"66199094-c3b2-48ec-a983-12b4eb680f04","queryName":"dimTiempo_minuto","queryGroupId":"3f38ade1-b5cf-40c8-aaa9-0cd226df948e","loadEnabled":true},"dimTiempo_Segundo":{"queryId":"62458b4d-43ed-4133-a14e-f263498dc4d7","queryName":"dimTiempo_Segundo","queryGroupId":"3f38ade1-b5cf-40c8-aaa9-0cd226df948e","loadEnabled":true}},"document":"section Section1;\r\nshared FechaInicio = let\r\n  FechaInicio = #date(2000, 1, 1) meta [IsParameterQuery = true, IsParameterQueryRequired = true, Type = type date]\r\nin\r\n  FechaInicio;\r\nshared FechaFin = let\r\n  FechaFin = #date(2050, 12, 31) meta [IsParameterQuery = true, IsParameterQueryRequired = true, Type = type date]\r\nin\r\n  FechaFin;\r\nshared NDias = let\r\n  Origen = Duration.Days(FechaFin-FechaInicio)+1\r\nin\r\n  Origen;\r\nshared dimFechas = let\r\n  Origen = List.Dates(FechaInicio,NDias,#duration(1,0,0,0)),\r\n  #\"Convertido en tabla\" = Table.FromList(Origen, Splitter.SplitByNothing(), null, null, ExtraValues.Error),\r\n  #\"Tipo de columna cambiado\" = Table.TransformColumnTypes(#\"Convertido en tabla\", {{\"Column1\", type datetime}}),\r\n  #\"Columnas con nombre cambiado\" = Table.RenameColumns(#\"Tipo de columna cambiado\", {{\"Column1\", \"Fecha\"}}),\r\n  #\"Tipo de columna cambiado 1\" = Table.TransformColumnTypes(#\"Columnas con nombre cambiado\", {{\"Fecha\", type date}}),\r\n  #\"Año insertado\" = Table.AddColumn(#\"Tipo de columna cambiado 1\", \"Año\", each Date.Year([Fecha]), type number),\r\n  #\"Columnas con nombre cambiado 1\" = Table.RenameColumns(#\"Año insertado\", {{\"Año\", \"Ejercicio\"}}),\r\n  #\"Mes insertado\" = Table.AddColumn(#\"Columnas con nombre cambiado 1\", \"Mes\", each Date.Month([Fecha]), type number),\r\n  #\"Columnas con nombre cambiado 2\" = Table.RenameColumns(#\"Mes insertado\", {{\"Mes\", \"MesNro\"}}),\r\n  #\"Nombre del mes insertado\" = Table.AddColumn(#\"Columnas con nombre cambiado 2\", \"Mes\", each Date.MonthName([Fecha]), type text),\r\n  #\"Texto en mayúsculas\" = Table.TransformColumns(#\"Nombre del mes insertado\", {{\"Mes\", each Text.Upper(_), type text}}),\r\n  #\"Día insertado\" = Table.AddColumn(#\"Texto en mayúsculas\", \"Día\", each Date.Day([Fecha]), Int64.Type),\r\n  #\"Columnas con nombre cambiado 3\" = Table.RenameColumns(#\"Día insertado\", {{\"Día\", \"Dia\"}}),\r\n  #\"Personalizado agregado\" = Table.AddColumn(#\"Columnas con nombre cambiado 3\", \"IdFecha\", each [Ejercicio]*10000 + [MesNro]*100 + [Dia], Int64.Type),\r\n  #\"Personalizado agregado 1\" = Table.AddColumn(#\"Personalizado agregado\", \"IdFechaEntero\", each Number.From([Fecha]), Int64.Type),\r\n  #\"Columnas con nombre cambiado 4\" = Table.RenameColumns(#\"Personalizado agregado 1\", {{\"Dia\", \"NroDia\"}}),\r\n  #\"Trimestre insertado\" = Table.AddColumn(#\"Columnas con nombre cambiado 4\", \"Trimestre\", each \"T\" & Text.From(Date.QuarterOfYear([Fecha])), type text),\r\n  #\"Día de la semana insertado\" = Table.AddColumn(#\"Trimestre insertado\", \"DiaSemana\", each Date.DayOfWeek([Fecha]) +1, Int64.Type),\r\n  #\"Semana del año insertada\" = Table.AddColumn(#\"Día de la semana insertado\", \"NroSemana\", each Date.WeekOfYear([Fecha]), Int64.Type),\r\n  #\"Personalizado agregado 2\" = Table.AddColumn(#\"Semana del año insertada\", \"Ejercicio-Trim.\", each Number.ToText([Ejercicio])&\"-\"&[Trimestre], type text),\r\n  #\"Primeros caracteres insertados\" = Table.AddColumn(#\"Personalizado agregado 2\", \"MesCorto\", each Text.Start([Mes], 3), type text),\r\n  #\"Columna condicional insertada\" = Table.AddColumn(#\"Primeros caracteres insertados\", \"EsLaborable\", each if [DiaSemana] <= 5 then 1 else 0, Int64.Type),\r\n  #\"Día del año insertado\" = Table.AddColumn(#\"Columna condicional insertada\", \"DiaEjercicio\", each Date.DayOfYear([Fecha]), Int64.Type),\r\n  #\"Personalizado agregado 3\" = Table.AddColumn(#\"Día del año insertado\", \"Ejercicio-Mes\", each Number.ToText([Ejercicio])&\"-\"&Text.End(\"0\"&Text.From([MesNro]),2)),\r\n  #\"Transformar columnas\" = Table.TransformColumnTypes(#\"Personalizado agregado 3\", {{\"Ejercicio-Mes\", type text}}),\r\n  #\"Reemplazar errores\" = Table.ReplaceErrorValues(#\"Transformar columnas\", {{\"Ejercicio-Mes\", null}}),\r\n  #\"Personalizado agregado 4\" = Table.AddColumn(#\"Reemplazar errores\", \"EjercicioActual\", each Date.Year(DateTime.LocalNow()), Int64.Type),\r\n  #\"Personalizado agregado 5\" = Table.AddColumn(#\"Personalizado agregado 4\", \"DesvioEjercicio\", each [Ejercicio] - [EjercicioActual], Int64.Type),\r\n  Personalizado = Table.AddColumn(#\"Personalizado agregado 5\", \"MesActual\", each Date.Month(DateTime.LocalNow()), Int64.Type),\r\n  #\"Personalizado 1\" = Table.AddColumn(Personalizado, \"HoyEntero\", each Number.RoundDown(Number.From(DateTime.LocalNow())), Int64.Type),\r\n  #\"Tipo de columna cambiado 2\" = Table.TransformColumnTypes(#\"Personalizado 1\", {{\"Fecha\", type datetime}}),\r\n  #\"Personalizado 2\" = Table.AddColumn(#\"Tipo de columna cambiado 2\", \"TrimestreActual\", each Date.QuarterOfYear(DateTime.LocalNow()), Int64.Type),\r\n  #\"Personalizado agregado 6\" = Table.AddColumn(#\"Personalizado 2\", \"Semestre\", each Number.RoundUp(Date.Month([Fecha])/6), Int64.Type),\r\n  #\"Personalizado agregado 7\" = Table.AddColumn(#\"Personalizado agregado 6\", \"DesvioMes\", each if [Ejercicio]=[EjercicioActual] then [MesNro]-[MesActual]\r\nelse\r\n\r\n[MesNro]-[MesActual]+([DesvioEjercicio]*12), Int64.Type),\r\n  #\"Personalizado agregado 8\" = Table.AddColumn(#\"Personalizado agregado 7\", \"DesvioDia\", each [IdFechaEntero] - [HoyEntero], Int64.Type),\r\n  #\"Personalizado agregado 9\" = Table.AddColumn(#\"Personalizado agregado 8\", \"HastaFecha\", each if [IdFechaEntero]<=[HoyEntero] then \"PASADO\"\r\nelse \"FUTURO\", type text),\r\n  #\"Personalizado agregado 10\" = Table.AddColumn(#\"Personalizado agregado 9\", \"TrimestreNro\", each Date.QuarterOfYear([Fecha]), Int64.Type),\r\n  #\"Personalizado 3\" = Table.AddColumn(#\"Personalizado agregado 10\", \"DesvioTrimestre\", each if [Ejercicio]=[EjercicioActual] then [TrimestreNro]-[TrimestreActual]\r\nelse\r\n\r\n[TrimestreNro]-[TrimestreActual]+([DesvioEjercicio]*4), Int64.Type),\r\n  #\"Personalizado 4\" = Table.AddColumn(#\"Personalizado 3\", \"SemestreActual\", each Number.RoundUp(Date.Month(DateTime.LocalNow())/6), Int64.Type),\r\n  #\"Personalizado 5\" = Table.AddColumn(#\"Personalizado 4\", \"DesvioSemestre\", each if [Ejercicio]=[EjercicioActual] then [Semestre]-[SemestreActual]\r\nelse\r\n[Semestre]-[SemestreActual]+([DesvioEjercicio]*2), Int64.Type)\r\nin\r\n  #\"Personalizado 5\";\r\nshared dimPeriodo = let\r\n  TodaysDate = Date.From(DateTimeZone.FixedUtcNow()),\r\n  Ranges = {\n                {\"Hoy\", \n                TodaysDate, \n                TodaysDate, \n                1},\n                {\"Ayer\", \n                Date.AddDays(TodaysDate,-1), \n                Date.AddDays(TodaysDate,-1), \n                2},\n                {\"Semana Actual hasta hoy\", \n                Date.From(Date.StartOfWeek(TodaysDate)), \n                TodaysDate, \n                3},\n                {\"Semana Actual\", \n                Date.From(Date.StartOfWeek(TodaysDate)), \n                Date.From(Date.EndOfWeek(TodaysDate)), \n                4},\n                {\"Mes Actual hasta hoy\", \n                Date.From(Date.StartOfMonth(TodaysDate)), \n                TodaysDate, \n                5},\n                {\"Mes Actual\", \n                Date.From(Date.StartOfMonth(TodaysDate)), \n                Date.From(Date.EndOfMonth(TodaysDate)), \n                6},\n                {\"Mes Anterior\", \n                Date.From(Date.StartOfMonth(Date.AddMonths(TodaysDate,-1))), \n                Date.From(Date.EndOfMonth(Date.AddMonths(TodaysDate,-1))), \n                7},\n                {\"Ejercicio Actual hasta hoy\", \n                Date.From(Date.StartOfYear(TodaysDate)), \n                TodaysDate, \n                8},\n                {\"Ejercicio Anterior\", \n                Date.From(Date.StartOfYear(Date.AddYears(TodaysDate,-1))), \n                Date.From(Date.EndOfYear(Date.AddYears(TodaysDate,-1))), \n                9},\n                {\"Ejercicio Actual\", \n                Date.From(Date.StartOfYear(TodaysDate)), \n                Date.From(Date.EndOfYear(TodaysDate)), \n                10},\n                {\"Ultimos 7 dias\", \n                Date.AddWeeks(TodaysDate,-1) + #duration(1,0,0,0), \n                TodaysDate, \n                12},\n                {\"Ultimos 30 días\", \n                Date.AddDays(TodaysDate,-30) + #duration(1,0,0,0), \n                TodaysDate, \n                11},\n                {\"Ultimos 365 días\", \n                Date.AddDays(TodaysDate,-365) + #duration(1,0,0,0), \n                TodaysDate, \n                13}\n             },\r\n  GetTables = List.Transform(Ranges, \n            each CreatePeriodTable(_{0}, _{1}, _{2}, _{3})),\r\n  Output = Table.Combine(GetTables),\r\n  #\"Tipo de columna cambiado\" = Table.TransformColumnTypes(Output, {{\"Date\", type datetime}})\r\nin\r\n  #\"Tipo de columna cambiado\";\r\nshared CreatePeriodTable = let\r\n  CreatePeriodTable = (\nPeriodName as text, \nStartDate as date, \nEndDate as date, \nSortOrder as number\n) as table =>\nlet\n    DayCount = Duration.Days(EndDate-StartDate)+1,\n    DateList = List.Dates(StartDate,DayCount,#duration(1,0,0,0)),\n    AddPeriodName = List.Transform(DateList, \n        each {PeriodName,_,SortOrder}),\n    CreateTable = #table(\n        type table[Period=text, Date=date, Sort=number], \n        AddPeriodName)\nin\n    CreateTable\r\nin\r\n  CreatePeriodTable;\r\nshared dimTiempo_minuto = let\r\n  // Lista de tiempos\r\n  Origen = List.Times(\n        #time(0,0,0),\n        24*60,\n        #duration(0,0,1,0)\n    ),\r\n  // Columnas principales\r\n  TablaDesdeLista = Table.FromList(Origen, Splitter.SplitByNothing(), null, null, ExtraValues.Error),\r\n  NombreCambiado = Table.RenameColumns(TablaDesdeLista, {{\"Column1\", \"Reloj\"}}),\r\n  TipoCambiado = Table.TransformColumnTypes(NombreCambiado, {{\"Reloj\", type time}}),\r\n  HoraNumeroInsertado = Table.AddColumn(TipoCambiado, \"HoraNumero\", each Time.Hour([Reloj]), Int64.Type),\r\n  MinutoNumeroInsertado = Table.AddColumn(HoraNumeroInsertado, \"MinutoNumero\", each Time.Minute([Reloj]), Int64.Type),\r\n  HoraTextoInsertado = Table.AddColumn(MinutoNumeroInsertado, \"HoraTexto\", each Text.PadStart(Text.From(Time.Hour([Reloj])),2,\"0\"), type text),\r\n  MinutoTextoInsertado = Table.AddColumn(HoraTextoInsertado, \"MinutoTexto\", each Text.PadStart(Text.From(Time.Minute([Reloj])),2,\"0\"), type text),\r\n  AMPMInsertado = Table.AddColumn(MinutoTextoInsertado, \"AM/PM\", each if [HoraNumero] < 12 then \"A.M\" else \"P.M\", type text),\r\n  HoraMinutoInsertado = Table.AddColumn(AMPMInsertado, \"HoraMinuto\", each Text.Combine({[HoraTexto], [MinutoTexto]}, \":\"), type text),\r\n  // Rangos de tiempo\r\n  InicioHoraInsertado = Table.AddColumn(HoraMinutoInsertado, \"InicioHora\", each Time.StartOfHour([Reloj]), type time),\r\n  ProximaHoraInsertado = Table.AddColumn(InicioHoraInsertado, \"ProximaHora\", each Value.Add([InicioHora],#duration(0,1,0,0))),\r\n  RangoHoraInsertado = Table.AddColumn(ProximaHoraInsertado, \"RangoHora\", each Text.Combine({Text.From([InicioHora], \"es-ES\"), Text.From([ProximaHora], \"es-ES\")}, \" - \"), type text),\r\n  ColumnaQuitada = Table.RemoveColumns(RangoHoraInsertado, {\"ProximaHora\"}),\r\n  InicioCuartoInsertado = Table.AddColumn(ColumnaQuitada, \"InicioCuarto\", each if [MinutoNumero] < 15 then [InicioHora] else \n        if [MinutoNumero] < 30 then Value.Add([InicioHora],#duration(0,0,15, 0)) else\n        if [MinutoNumero] < 45 then Value.Add([InicioHora],#duration(0,0,30, 0)) else Value.Add([InicioHora],#duration(0,0,45, 0))),\r\n  ProximoCuartoInsertado = Table.AddColumn(InicioCuartoInsertado, \"ProximoCuarto\", each Value.Add([InicioCuarto],#duration(0,0,15, 0))),\r\n  RangoCuartosTransformado = Table.CombineColumns(Table.TransformColumnTypes(ProximoCuartoInsertado, {{\"InicioCuarto\", type text}, {\"ProximoCuarto\", type text}}, \"es-ES\"), {\"InicioCuarto\", \"ProximoCuarto\"}, Combiner.CombineTextByDelimiter(\" - \", QuoteStyle.None), \"RangoCuartos\"),\r\n  InicioMediasHorasInsertado = Table.AddColumn(RangoCuartosTransformado, \"InicioMediasHoras\", each if[MinutoNumero]<30 then [InicioHora] else Value.Add([InicioHora],#duration(0,0,30,0))),\r\n  ProximaMediaHoraInsertado = Table.AddColumn(InicioMediasHorasInsertado, \"ProximaMediaHora\", each Value.Add([InicioHora],#duration(0,0,30,0))),\r\n  RangoMediasTransformado = Table.CombineColumns(Table.TransformColumnTypes(ProximaMediaHoraInsertado, {{\"InicioMediasHoras\", type text}, {\"ProximaMediaHora\", type text}}, \"es-ES\"), {\"InicioMediasHoras\", \"ProximaMediaHora\"}, Combiner.CombineTextByDelimiter(\" - \", QuoteStyle.None), \"RangoMedias\"),\r\n  // Periodo de tiempo y RelojKey\r\n  PeriodoInsertado = Table.AddColumn(RangoMediasTransformado, \"Periodo\", each if [HoraNumero]<3 then \"Madrugada\" else\n        if [HoraNumero]<10 then \"Cerrado\" else \n        if [HoraNumero]<12 then \"Mañana\" else \n        if [HoraNumero]<16 then \"Mediodia\" else\n        if [HoraNumero]<20 then \"Tarde\" else \"Noche\", type text),\r\n  OrdenadorPeriodoInsertado = Table.AddColumn(PeriodoInsertado, \"OrdenadorPeriodo\", each if [HoraNumero]<3 then 6 else\n        if [HoraNumero]<10 then 1 else \n        if [HoraNumero]<12 then 2 else \n        if [HoraNumero]<16 then 3 else\n        if [HoraNumero]<20 then 4 else 5, Int64.Type),\r\n  RelojKeyInsertado = Table.AddColumn(OrdenadorPeriodoInsertado, \"RelojKey\", each [HoraNumero]*100+[MinutoNumero], Int64.Type)\r\nin\r\n  RelojKeyInsertado;\r\nshared dimTiempo_Segundo = let\r\n  Source = List.Times(#time(0,0,0),24*60*60,#duration(0,0,0,1)),\r\n  #\"Converted to Table\" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),\r\n  #\"Renamed Columns\" = Table.RenameColumns(#\"Converted to Table\", {{\"Column1\", \"Tiempo\"}}),\r\n  #\"Changed Type\" = Table.TransformColumnTypes(#\"Renamed Columns\", {{\"Tiempo\", type time}}),\r\n  #\"Inserted Hour\" = Table.AddColumn(#\"Changed Type\", \"Hora\", each Time.Hour([Tiempo]), Int64.Type),\r\n  #\"Inserted Minute\" = Table.AddColumn(#\"Inserted Hour\", \"Minuto\", each Time.Minute([Tiempo]), Int64.Type),\r\n  #\"Inserted Second\" = Table.AddColumn(#\"Inserted Minute\", \"Segundo\", each Time.Second([Tiempo]), type number),\r\n  #\"Added Conditional Column\" = Table.AddColumn(#\"Inserted Second\", \"AM/PM\", each if [Hora] < 12 then \"a.m.\" else \"p.m.\"),\r\n  #\"Changed Type1\" = Table.TransformColumnTypes(#\"Added Conditional Column\", {{\"AM/PM\", type text}}),\r\n  #\"Duplicated Column\" = Table.DuplicateColumn(#\"Changed Type1\", \"Tiempo\", \"Tiempo - Copy\"),\r\n  #\"Removed Columns\" = Table.RemoveColumns(#\"Duplicated Column\", {\"Tiempo - Copy\"}),\r\n  #\"Duplicated Column1\" = Table.DuplicateColumn(#\"Removed Columns\", \"Hora\", \"Hora - Copy\"),\r\n  #\"Renamed Columns1\" = Table.RenameColumns(#\"Duplicated Column1\", {{\"Hora - Copy\", \"Hora txt\"}}),\r\n  #\"Changed Type2\" = Table.TransformColumnTypes(#\"Renamed Columns1\", {{\"Hora txt\", type text}}),\r\n  #\"Removed Columns1\" = Table.RemoveColumns(#\"Changed Type2\", {\"Hora txt\"}),\r\n  #\"Inserted Prefix\" = Table.AddColumn(#\"Removed Columns1\", \"Prefix\", each \"0\" & Text.From([Hora], \"es-es\"), type text),\r\n  #\"Renamed Columns2\" = Table.RenameColumns(#\"Inserted Prefix\", {{\"Prefix\", \"Hora txt\"}}),\r\n  #\"Extracted Last Characters\" = Table.TransformColumns(#\"Renamed Columns2\", {{\"Hora txt\", each Text.End(_, 2), type text}}),\r\n  #\"Inserted Prefix1\" = Table.AddColumn(#\"Extracted Last Characters\", \"Prefix\", each \"0\" & Text.From([Minuto], \"es-es\"), type text),\r\n  #\"Renamed Columns3\" = Table.RenameColumns(#\"Inserted Prefix1\", {{\"Prefix\", \"Minuto txt\"}}),\r\n  #\"Extracted Last Characters1\" = Table.TransformColumns(#\"Renamed Columns3\", {{\"Minuto txt\", each Text.End(_, 2), type text}}),\r\n  #\"Inserted Prefix2\" = Table.AddColumn(#\"Extracted Last Characters1\", \"Prefix\", each \"0\" & Text.From([Segundo], \"es-es\"), type text),\r\n  #\"Renamed Columns4\" = Table.RenameColumns(#\"Inserted Prefix2\", {{\"Prefix\", \"Segundo txt\"}}),\r\n  #\"Extracted Last Characters2\" = Table.TransformColumns(#\"Renamed Columns4\", {{\"Segundo txt\", each Text.End(_, 2), type text}}),\r\n  #\"Added Index\" = Table.AddIndexColumn(#\"Extracted Last Characters2\", \"Index\", 0, 1),\r\n  #\"Renamed Columns5\" = Table.RenameColumns(#\"Added Index\", {{\"Index\", \"IdTiempo\"}}),\r\n  #\"Inserted Modulo\" = Table.AddColumn(#\"Renamed Columns5\", \"Modulo\", each Number.Mod([Hora], 12), type number),\r\n  #\"Renamed Columns6\" = Table.RenameColumns(#\"Inserted Modulo\", {{\"Modulo\", \"Hora Bin 12\"}}),\r\n  #\"Inserted Integer-Division\" = Table.AddColumn(#\"Renamed Columns6\", \"Integer-Division\", each Number.IntegerDivide([Hora], 8), Int64.Type),\r\n  #\"Renamed Columns7\" = Table.RenameColumns(#\"Inserted Integer-Division\", {{\"Integer-Division\", \"Hora Bin 8\"}}),\r\n  #\"Inserted Integer-Division1\" = Table.AddColumn(#\"Renamed Columns7\", \"Integer-Division\", each Number.IntegerDivide([Hora], 6), Int64.Type),\r\n  #\"Renamed Columns8\" = Table.RenameColumns(#\"Inserted Integer-Division1\", {{\"Integer-Division\", \"Hora Bin 6\"}}),\r\n  #\"Inserted Integer-Division2\" = Table.AddColumn(#\"Renamed Columns8\", \"Integer-Division\", each Number.IntegerDivide([Hora], 4), Int64.Type),\r\n  #\"Renamed Columns9\" = Table.RenameColumns(#\"Inserted Integer-Division2\", {{\"Integer-Division\", \"Hora Bin 4\"}}),\r\n  #\"Inserted Integer-Division3\" = Table.AddColumn(#\"Renamed Columns9\", \"Integer-Division\", each Number.IntegerDivide([Hora], 3), Int64.Type),\r\n  #\"Renamed Columns10\" = Table.RenameColumns(#\"Inserted Integer-Division3\", {{\"Integer-Division\", \"Hora Bin 3\"}}),\r\n  #\"Inserted Integer-Division4\" = Table.AddColumn(#\"Renamed Columns10\", \"Integer-Division\", each Number.IntegerDivide([Hora], 2), Int64.Type),\r\n  #\"Renamed Columns11\" = Table.RenameColumns(#\"Inserted Integer-Division4\", {{\"Integer-Division\", \"Hora Bin 2\"}}),\r\n  #\"Inserted Integer-Division5\" = Table.AddColumn(#\"Renamed Columns11\", \"Integer-Division\", each Number.IntegerDivide([Minuto], 30), Int64.Type),\r\n  #\"Multiplied Column\" = Table.TransformColumns(#\"Inserted Integer-Division5\", {{\"Integer-Division\", each _ * 30, type number}}),\r\n  #\"Renamed Columns12\" = Table.RenameColumns(#\"Multiplied Column\", {{\"Integer-Division\", \"Minuto Bin 30\"}}),\r\n  #\"Inserted Integer-Division6\" = Table.AddColumn(#\"Renamed Columns12\", \"Integer-Division\", each Number.IntegerDivide([Minuto], 15), Int64.Type),\r\n  #\"Multiplied Column1\" = Table.TransformColumns(#\"Inserted Integer-Division6\", {{\"Integer-Division\", each _ * 15, type number}}),\r\n  #\"Renamed Columns13\" = Table.RenameColumns(#\"Multiplied Column1\", {{\"Integer-Division\", \"Minuto Bin 15\"}}),\r\n  #\"Inserted Integer-Division7\" = Table.AddColumn(#\"Renamed Columns13\", \"Integer-Division\", each Number.IntegerDivide([Minuto], 10), Int64.Type),\r\n  #\"Multiplied Column2\" = Table.TransformColumns(#\"Inserted Integer-Division7\", {{\"Integer-Division\", each _ * 10, type number}}),\r\n  #\"Renamed Columns14\" = Table.RenameColumns(#\"Multiplied Column2\", {{\"Integer-Division\", \"Minuto Bin 10\"}})\r\nin\r\n  #\"Renamed Columns14\";\r\n"},"annotations":[{"name":"pbi:QueryGroups","value":"[{\"id\":\"e5788d00-b118-4f36-8c24-0f497892395b\",\"name\":\"PARAMETROS\",\"description\":\"\",\"parentId\":null,\"order\":0},{\"id\":\"844b4c37-ac10-4a19-bc71-22006bddf0d3\",\"name\":\"FUNCIONES\",\"description\":\"\",\"parentId\":null,\"order\":1},{\"id\":\"3f38ade1-b5cf-40c8-aaa9-0cd226df948e\",\"name\":\"DIMENSIONES\",\"description\":\"\",\"parentId\":null,\"order\":2}]"}],"entities":[{"$type":"LocalEntity","name":"dimFechas","description":"","pbi:refreshPolicy":{"$type":"FullRefreshPolicy","location":"dimFechas.csv"},"attributes":[{"name":"Fecha","dataType":"dateTime"},{"name":"Ejercicio","dataType":"double"},{"name":"MesNro","dataType":"double"},{"name":"Mes","dataType":"string"},{"name":"NroDia","dataType":"int64"},{"name":"IdFecha","dataType":"int64"},{"name":"IdFechaEntero","dataType":"int64"},{"name":"Trimestre","dataType":"string"},{"name":"DiaSemana","dataType":"int64"},{"name":"NroSemana","dataType":"int64"},{"name":"Ejercicio-Trim.","dataType":"string"},{"name":"MesCorto","dataType":"string"},{"name":"EsLaborable","dataType":"int64"},{"name":"DiaEjercicio","dataType":"int64"},{"name":"Ejercicio-Mes","dataType":"string"},{"name":"EjercicioActual","dataType":"int64"},{"name":"DesvioEjercicio","dataType":"int64"},{"name":"MesActual","dataType":"int64"},{"name":"HoyEntero","dataType":"int64"},{"name":"TrimestreActual","dataType":"int64"},{"name":"Semestre","dataType":"int64"},{"name":"DesvioMes","dataType":"int64"},{"name":"DesvioDia","dataType":"int64"},{"name":"HastaFecha","dataType":"string"},{"name":"TrimestreNro","dataType":"int64"},{"name":"DesvioTrimestre","dataType":"int64"},{"name":"SemestreActual","dataType":"int64"},{"name":"DesvioSemestre","dataType":"int64"}],"partitions":[{"name":"Part001","refreshTime":"2020-11-14T13:12:33.6616462+00:00","location":"https://wabiweubpcdsa.blob.core.windows.net:443/181395c7-2e34-48b8-90b5-fe25d262b15a/dimFechas.csv?snapshot=2020-11-14T13%3A12%3A33.6545292Z"}]},{"$type":"LocalEntity","name":"dimPeriodo","description":"","pbi:refreshPolicy":{"$type":"FullRefreshPolicy","location":"dimPeriodo.csv"},"attributes":[{"name":"Period","dataType":"string"},{"name":"Date","dataType":"dateTime"},{"name":"Sort","dataType":"double"}],"partitions":[{"name":"Part001","refreshTime":"2020-11-14T13:13:04.2628519+00:00","location":"https://wabiweubpcdsa.blob.core.windows.net:443/181395c7-2e34-48b8-90b5-fe25d262b15a/dimPeriodo.csv?snapshot=2020-11-14T13%3A13%3A04.2560871Z"}]},{"$type":"LocalEntity","name":"dimTiempo_minuto","description":"","pbi:refreshPolicy":{"$type":"FullRefreshPolicy","location":"dimTiempo_minuto.csv"},"attributes":[{"name":"Reloj","dataType":"time"},{"name":"HoraNumero","dataType":"int64"},{"name":"MinutoNumero","dataType":"int64"},{"name":"HoraTexto","dataType":"string"},{"name":"MinutoTexto","dataType":"string"},{"name":"AM/PM","dataType":"string"},{"name":"HoraMinuto","dataType":"string"},{"name":"InicioHora","dataType":"time"},{"name":"RangoHora","dataType":"string"},{"name":"RangoCuartos","dataType":"string"},{"name":"RangoMedias","dataType":"string"},{"name":"Periodo","dataType":"string"},{"name":"OrdenadorPeriodo","dataType":"int64"},{"name":"RelojKey","dataType":"int64"}],"partitions":[{"name":"Part001","refreshTime":"2020-11-14T13:13:35.0960981+00:00","location":"https://wabiweubpcdsa.blob.core.windows.net:443/181395c7-2e34-48b8-90b5-fe25d262b15a/dimTiempo_minuto.csv?snapshot=2020-11-14T13%3A13%3A35.0888137Z"}]},{"$type":"LocalEntity","name":"dimTiempo_Segundo","description":"","pbi:refreshPolicy":{"$type":"FullRefreshPolicy","location":"dimTiempo_Segundo.csv"},"attributes":[{"name":"Tiempo","dataType":"time"},{"name":"Hora","dataType":"int64"},{"name":"Minuto","dataType":"int64"},{"name":"Segundo","dataType":"double"},{"name":"AM/PM","dataType":"string"},{"name":"Hora txt","dataType":"string"},{"name":"Minuto txt","dataType":"string"},{"name":"Segundo txt","dataType":"string"},{"name":"IdTiempo","dataType":"double"},{"name":"Hora Bin 12","dataType":"double"},{"name":"Hora Bin 8","dataType":"int64"},{"name":"Hora Bin 6","dataType":"int64"},{"name":"Hora Bin 4","dataType":"int64"},{"name":"Hora Bin 3","dataType":"int64"},{"name":"Hora Bin 2","dataType":"int64"},{"name":"Minuto Bin 30","dataType":"double"},{"name":"Minuto Bin 15","dataType":"double"},{"name":"Minuto Bin 10","dataType":"double"}],"partitions":[{"name":"Part001","refreshTime":"2020-11-14T13:14:05.7753584+00:00","location":"https://wabiweubpcdsa.blob.core.windows.net:443/181395c7-2e34-48b8-90b5-fe25d262b15a/dimTiempo_Segundo.csv?snapshot=2020-11-14T13%3A14%3A05.7654249Z"}]}]}