Bonjour à tous !
Une proposition ?
let
Source = Excel.CurrentWorkbook(){[Name="Tableau1"]}[Content],
TransfDate = let
fnDate=(ValDate)=>Text.Upper(Date.MonthName(Date.FromText(Text.Range(ValDate,0,8)&"01"))),
a=Table.AddColumn(Source,"Date", each
if Text.EndsWith([DATE TEXTE],"TM") then fnDate([DATE TEXTE])
else if Text.EndsWith([DATE TEXTE],"é") then "CUMUL " & fnDate([DATE TEXTE])
else if Text.StartsWith([DATE TEXTE],"T") then Text.Start(Source[DATE TEXTE]{0},4)
else Date.FromText([DATE TEXTE],"fr-FR")
)
in
a,
TransfDate2 =
let
fnDate2=(ValDate)=>Date.FromText(Text.Range(ValDate,0,8)&"01"),
a= Table.AddColumn(TransfDate,"Année", each Date.Year(fnDate2([DATE TEXTE])), Int64.Type),
b= Table.AddColumn(a,"Mois", each Text.Upper(Date.MonthName(fnDate2([DATE TEXTE]))), Text.Type)
in
b
in
TransfDate2
Note : La première transformation a été conservée. A supprimer le cas échéant.