季度功率bi

我正在尝试从日期开始四分之一..

我尝试了此查询

let
    Source = "",Custom1 = Source,Custom2 = Calendar2,Custom3 = let
    Source = List.Dates(#date(1996,1,1),500,#duration(1,0)),#"Converted to Table" = Table.FromList(Source,Splitter.SplitByNothing(),null,ExtraValues.Error),#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1","Date"}}),#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date",type date}}),StartDate = #date(2016,Today = DateTime.Date(DateTime.LocalNow()),Length = Duration.Days(Today - StartDate),Custom1 = #"Changed Type",#"Inserted Year" = Table.AddColumn(Custom1,"Fin Year",each Date.Year([Date]+#duration(184,Int64.Type),#"Inserted Month Name" = Table.AddColumn(#"Inserted Year","Month Name",each Date.MonthName([Date]),type text),#"Inserted Day Name" = Table.AddColumn(#"Inserted Month Name","Day Name",each Date.DayOfWeekName([Date]),#"Inserted Quarter of Year"= Table.AddColumn(#"Inserted Quarter of Year","Quarter of Year",each Date.QuarterOfYear([Date]),#"Inserted Month" = Table.AddColumn(#"Inserted Day Name","Fin Month",each if Date.Month([Date]) >=7 then Date.Month([Date])-6 else Date.Month([Date])+6,#"Inserted Day of Week" = Table.AddColumn(#"Inserted Month","Day of Week",each Date.DayOfWeek([Date])+1,#"Inserted First Characters" = Table.AddColumn(#"Inserted Day of Week","MMM",each Text.Start([Month Name],3),#"Inserted First Characters1" = Table.AddColumn(#"Inserted First Characters","DDD",each Text.Start([Day Name],#"Reordered Columns" = Table.ReorderColumns(#"Inserted First Characters1",{"Date","Day of Week"}),#"Added Custom" = Table.AddColumn(#"Reordered Columns","YYMM",each ([Fin Year]-2000)*100 + [Fin Month]),#"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"YYMM",Int64.Type}}),#"Added Custom1" = Table.AddColumn(#"Changed Type1","MonthID",each (Date.Year([Date]) - Date.Year(StartDate))*12 + Date.Month([Date])),#"Changed Type2" = Table.TransformColumnTypes(#"Added Custom1",{{"MonthID",Int64.Type}})

in
    #"Changed Type2"
in
    Custom3

以上代码的四分之一行

#"Inserted Quarter of Year"= Table.AddColumn(#"Inserted Quarter of Year",

当我尝试显示错误

Expression.Error:无法识别名称“插入年份的季度”。确保拼写正确。

并且当我将“ Fin Month”重命名为“ Month”时也有问题,这也会显示错误

如何解决此问题

ttqqcw 回答:季度功率bi

您的语法有误,并且自我引用了您要创建的列,您需要参考上一步。

插入年份的季度

#"Inserted Quarter of Year"= Table.AddColumn(#"Inserted Quarter of Year","Quarter of Year",each Date.QuarterOfYear([Date]),Int64.Type),

应为:

#"Inserted Quarter of Year"= Table.AddColumn(#"Inserted Day Name",Int64.Type)

enter image description here

希望有帮助

本文链接:https://www.f2er.com/3082682.html

大家都在问