Needs per month

Hello Anonymous 

I assumed now that M is the current month, M1 the next month etc. Therefore I created for you a custom function where you can achive this. Here the code that does the trick

let
    Quelle = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hZNBEsQgCAT/4pkDoER9S2r//40Fc9gCMXswFW3RYZK579LqQCxQSEdDBGz2Uvuk8oEfZh0XIFJK6ypWnBfb6rCzR4plYa3O8aXDdOW0m3a9u6fUagSBJKXTalnPJk45rYfYhivfYHawdXY4wJaFOsjM1VNd8gFrrpDaakAvOHD5p9CWWb196ofOHR7e+43Px3yhFDM69zf8/FRQOcfsvs6Gmzd34/LaGlvnFRkO0k2yqG+H6uGN34zxcRlNXuISaYhLxCEuEYe4ROzjEqmPS6Q+LpHGuES+xWVt+HwB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Date de l'extraction" = _t, #"Code article" = _t, #"Quantitè requise" = _t, #"Date du besoin" = _t]),
    TransformToDate = Table.TransformColumns(Quelle,{{"Date de l'extraction", each Date.From(Number.From(_)), type date},{"Date du besoin", each Date.From(Number.From(_)), type date}}),
    ChangeType = Table.TransformColumnTypes(TransformToDate,{{"Quantitè requise", type number}}),
    CalculateDifferenceMonth = (datetocalculate as date) as number =>
    let
        Monthcalc = Date.Month(Date.From(datetocalculate)),
        Yearcalc = Date.Year(Date.From(datetocalculate)),
        Monthcurr = Date.Month( DateTime.FixedLocalNow()),
        Yearcurr = Date.Year(DateTime.FixedLocalNow()),

        MonthDiff =(Monthcalc-Monthcurr), // -
        YearDiffinMonths = ((Yearcurr-Yearcalc)*12),
        Result = MonthDiff  - YearDiffinMonths
    in
        Result,
    
    RecalculteDateDuBesoin =  Table.TransformColumns
    (
        ChangeType,
        {
            {"Date du besoin", each "M"&Text.From(CalculateDifferenceMonth(_)) }
        } 
    ),
    Pivot = Table.Pivot
    (
        RecalculteDateDuBesoin, 
        List.Distinct(RecalculteDateDuBesoin[#"Date du besoin"]), 
        "Date du besoin", 
        "Quantitè requise", 
        List.Sum
    )
in
    Pivot

Copy paste this code to the advanced editor to see how the solution works

If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy