Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hola a todos,
He creado un escritorio de tabla de calendario con Power BI Desktop
Solved! Go to Solution.
@prkhan56 No estaba seguro de si quería crear una tabla de fechas en Power Query, pero ésta es la que utilizo:
let
Source = #date(2011, 1, 1),Encoding = 65001,
#"Convert to List" = List.Dates(Source, Number.From(#date(2020,12,31))-Number.From(Source),#duration(1,0,0,0)),
#"Converted to Table" = Table.FromList(#"Convert to List", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Renamed Column to Date" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Date Range"}}),
#"Changed Type to Date" = Table.TransformColumnTypes(#"Renamed Column to Date",{{"Date Range", type date}}),
#"Inserted Year" = Table.AddColumn(#"Changed Type to Date", "Year", each Date.Year([Date Range]), Int64.Type),
#"Inserted Start of Year" = Table.AddColumn(#"Inserted Year", "Start of Year", each Date.StartOfYear([Date Range]), type date),
#"Inserted End of Year" = Table.AddColumn(#"Inserted Start of Year", "End of Year", each Date.EndOfYear([Date Range]), type date),
#"Inserted End of Month" = Table.AddColumn(#"Inserted End of Year", "End of Month", each Date.EndOfMonth([Date Range]), type date),
#"Inserted Month Name" = Table.AddColumn(#"Inserted End of Month", "Month Name", each Date.MonthName([Date Range]), type text),
#"Inserted Start of Week" = Table.AddColumn(#"Inserted Month Name", "Start of Week", each Date.StartOfWeek([Date Range]), type date),
#"Inserted End of Week" = Table.AddColumn(#"Inserted Start of Week", "End of Week", each Date.EndOfWeek([Date Range]), type date),
#"Duplicated Column" = Table.DuplicateColumn(#"Inserted End of Week", "Date Range", "Weekday"),
#"Create Weekday" = Table.TransformColumns(#"Duplicated Column", {{"Weekday", each Date.DayOfWeekName(_), type text}}),
#"Duplicated Column1" = Table.DuplicateColumn(#"Create Weekday", "Date Range", "Week of Year"),
#"Calculated Week of Year" = Table.TransformColumns(#"Duplicated Column1",{{"Week of Year", Date.WeekOfYear, Int64.Type}}),
#"Inserted Quarter" = Table.AddColumn(#"Calculated Week of Year", "Quarters", each "Q" & Number.ToText(Date.QuarterOfYear([Date Range])),type text),
#"Inserted End of Quarter" = Table.AddColumn(#"Inserted Quarter", "End of Quarter", each Date.EndOfQuarter([Date Range]), type date)
in
#"Inserted End of Quarter"
Proud to be a Super User!
@prkhan56 No estaba seguro de si quería crear una tabla de fechas en Power Query, pero ésta es la que utilizo:
let
Source = #date(2011, 1, 1),Encoding = 65001,
#"Convert to List" = List.Dates(Source, Number.From(#date(2020,12,31))-Number.From(Source),#duration(1,0,0,0)),
#"Converted to Table" = Table.FromList(#"Convert to List", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Renamed Column to Date" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Date Range"}}),
#"Changed Type to Date" = Table.TransformColumnTypes(#"Renamed Column to Date",{{"Date Range", type date}}),
#"Inserted Year" = Table.AddColumn(#"Changed Type to Date", "Year", each Date.Year([Date Range]), Int64.Type),
#"Inserted Start of Year" = Table.AddColumn(#"Inserted Year", "Start of Year", each Date.StartOfYear([Date Range]), type date),
#"Inserted End of Year" = Table.AddColumn(#"Inserted Start of Year", "End of Year", each Date.EndOfYear([Date Range]), type date),
#"Inserted End of Month" = Table.AddColumn(#"Inserted End of Year", "End of Month", each Date.EndOfMonth([Date Range]), type date),
#"Inserted Month Name" = Table.AddColumn(#"Inserted End of Month", "Month Name", each Date.MonthName([Date Range]), type text),
#"Inserted Start of Week" = Table.AddColumn(#"Inserted Month Name", "Start of Week", each Date.StartOfWeek([Date Range]), type date),
#"Inserted End of Week" = Table.AddColumn(#"Inserted Start of Week", "End of Week", each Date.EndOfWeek([Date Range]), type date),
#"Duplicated Column" = Table.DuplicateColumn(#"Inserted End of Week", "Date Range", "Weekday"),
#"Create Weekday" = Table.TransformColumns(#"Duplicated Column", {{"Weekday", each Date.DayOfWeekName(_), type text}}),
#"Duplicated Column1" = Table.DuplicateColumn(#"Create Weekday", "Date Range", "Week of Year"),
#"Calculated Week of Year" = Table.TransformColumns(#"Duplicated Column1",{{"Week of Year", Date.WeekOfYear, Int64.Type}}),
#"Inserted Quarter" = Table.AddColumn(#"Calculated Week of Year", "Quarters", each "Q" & Number.ToText(Date.QuarterOfYear([Date Range])),type text),
#"Inserted End of Quarter" = Table.AddColumn(#"Inserted Quarter", "End of Quarter", each Date.EndOfQuarter([Date Range]), type date)
in
#"Inserted End of Quarter"
Proud to be a Super User!
@prkhan56 si ha creado una tabla mediante la expresión DAX, no se mostrará en PQ. Puedes crear un calendario usando PQ, hay un montón de publicaciones sobre cómo crear uno.
Consulta mi última entrada de blog Año-2020, Pandemia, Power BI y más allá para obtener un resumen de mis versiones favoritas de las características de Power BI en 2020
Me gustaría ❤ elogios si mi solución ayudara. 👉 Si puedes dedicar tiempo a publicar la pregunta, también puedes hacer esfuerzos para dar Felicitaciones a quien haya ayudado a resolver tu problema. ¡Es una muestra de agradecimiento!
⚡Visítenos en https://perytus.com, su ventanilla única para proyectos/formación/consulta relacionadas con Power BI.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |