selectionner la date la plus ancienne

Home › Forums › Power BI › selectionner la date la plus ancienne

  • This topic has 1 reply, 2 voices, and was last updated 2 years ago by Xavier Allart.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • 9 October 2023 at 12 h 30 min #133443
    messoud85
    Participant

    bonjour,

    j’ai plusieurs date dans chaque colonne et je souhaite ajouter une colonne pour choisir la date la plus ancienne de chaque ligne (voir image ci-joint). quelle formule utiliser sur power bi?

    merci,

    Attachments:
    You must be logged in to view attached files.
    10 October 2023 at 23 h 41 min #133468
    Xavier Allart
    Participant

    Bonjour

    Voici une proposition :

    let
    Source = Excel.CurrentWorkbook(){[Name=”Tableau1″]}[Content],
    #”Type modifié” = Table.TransformColumnTypes(Source, {
    {“iD”, type text},
    {“WEC Final-assembly Disp. Start”, type date},
    {“WEC Final-assembly Disp. End”, type date},
    {“WEC Final-assembly Act Start”, type date},
    {“WEC Final-assembly Act End”, type date}
    }),
    P1 = Table.AddColumn(#”Type modifié”, “P1″, each List.Min(List.RemoveNulls({
    [#”WEC Final-assembly Disp. Start”],
    [#”WEC Final-assembly Disp. End”],
    [#”WEC Final-assembly Act Start”],
    [#”WEC Final-assembly Act End”]
    })))
    in
    P1

    Cordialement

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.