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
İ necesita su ayuda sobre abajo ıssue
Estoy tratando de crear una tabla de dimensiones y entro en la siguiente fórmula para "editor de avance" en la consulta después de tha una apertura de pantalla functıon ınvoke , aquí escribo inicio de fecha , en de fecha de inicio de fecha de fıscal mes.
para mí necesito que el inicio del mes fiscal es "abril"
sistema crating tabla todo parece bien, pero para la fecha de hoy, por ejemplo, el sistema dice que el año fiscal es "FY22". Pero quiero que mayo de 2021 sea "FY21". quiero decir 01.04.2021 a 31.03.2022 debe ser "FY21".
Cómo puedo i resolver este asunto podrías ayudarme pls ?
let fnDateTable = (StartDate como fecha, EndDate como fecha, FYStartMonth como número) como tabla =>
dejar
DayCount = Duration.Days(Duration.From(EndDate - StartDate)),
Origen = List.Dates(StartDate,DayCount,#duration(1,0,0,0)),
TableFromList = Table.FromList(Source, Splitter.SplitByNothing()),
ChangedType = Table.TransformColumnTypes(TableFromList,{{"Column1", escriba date}}),
RenamedColumns = Table.RenameColumns(ChangedType,{{"Column1", "Date"}}),
InsertYear = Table.AddColumn(RenamedColumns, "Year", cada Date.Year([Date]),escriba texto),
InsertYearNumber = Table.AddColumn(RenamedColumns, "YearNumber", cada Date.Year([Date])),
InsertQuarter = Table.AddColumn(InsertYear, "QuarterOfYear", cada Date.QuarterOfYear([Date])),
InsertMonth = Table.AddColumn(InsertQuarter, "MonthOfYear", cada Date.Month([Date]), escriba texto),
InsertDay = Table.AddColumn(InsertMonth, "DayOfMonth", cada Date.Day([Date])),
InsertDayInt = Table.AddColumn(InsertDay, "DateInt", cada [Año] * 10000 + [MonthOfYear] * 100 + [DayOfMonth]),
InsertMonthName = Table.AddColumn(InsertDayInt, "MonthName", cada Date.ToText([Date], "MMMM"), escriba texto),
InsertCalendarMonth = Table.AddColumn(InsertMonthName, "MonthInCalendar", cada uno (try(Text.Range([MonthName],0,3)) de lo contrario [MonthName]) & " " & Number.ToText([Year])),
InsertCalendarqtr = Table.AddColumn(InsertCalendarMonth, "QuarterInCalendar", cada "Q" & Number.ToText([QuarterOfYear]) & " " & Number.ToText([Year])),
InsertDayWeek = Table.AddColumn(InsertCalendarQtr, "DayInWeek", cada Date.DayOfWeek([Date])),
InsertDayName = Table.AddColumn(InsertDayWeek, "DayOfWeekName", cada Date.ToText([Date], "dddd"), escriba text),
InsertWeekEnding = Table.AddColumn(InsertDayName, "WeekEnding", cada Date.EndOfWeek([Date]), escriba date),
InsertWeekNumber= Table.AddColumn(InsertWeekEnding, "Número de semana", cada Date.WeekOfYear([Date])),
InsertMonthnYear = Table.AddColumn(InsertWeekNumber,"MonthnYear", cada [Año] * 10000 + [MonthOfYear] * 100),
InsertQuarternYear = Table.AddColumn(InsertMonthnYear,"QuarternYear", cada [Año] * 10000 + [QuarterOfYear] * 100),
ChangedType1 = Table.TransformColumnTypes(InsertQuarternYear,{{"QuarternYear", Int64.Type},{"Week Number", Int64.Type},{"Year", type text},{"MonthnYear", Int64.Type}, {"DateInt", Int64.Type}, {"DayOfMonth", Int64.Type}, {"MonthOfYear", Int64.Type}, {"QuarterOfYear", Int64.Type}, {"MonthInCalendar", type text}, {"QuarterInCalendar", type text}, {"DayInWeek", Int64.Type}}),
InsertShortYear = Table.AddColumn(ChangedType1, "ShortYear", cada Text.End(Text.From([Year]), 2), escriba texto),
AddFY = Table.AddColumn(InsertShortYear, "FY", cada "FY"&(if [MonthOfYear]>=FYStartMonth then Text.From(Number.From([ShortYear])+1) else [ShortYear]))
en
AddFY
en
fnDateTable
Solved! Go to Solution.
Intente cambiar
Table.AddColumn(InsertShortYear, "FY", each "FY"&(if [MonthOfYear]>=FYStartMonth then Text.From(Number.From([ShortYear])+1) else [ShortYear]))
Para
AddFY = Table.AddColumn(InsertShortYear, "FY", each "FY"&(if [MonthOfYear]>=FYStartMonth then [ShortYear] else Text.From(Number.From([ShortYear])-1) ))
Intente cambiar
Table.AddColumn(InsertShortYear, "FY", each "FY"&(if [MonthOfYear]>=FYStartMonth then Text.From(Number.From([ShortYear])+1) else [ShortYear]))
Para
AddFY = Table.AddColumn(InsertShortYear, "FY", each "FY"&(if [MonthOfYear]>=FYStartMonth then [ShortYear] else Text.From(Number.From([ShortYear])-1) ))
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 |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |