Forum Discussion

patri0t82's avatar
patri0t82
Post Patron
3 years ago
Solved

Year to Date SUM

Hi! I'm using Power Query and I need help creating a new column. I have a column called [Month / Year], which is a date column. It contains one row per month. Each row looks like this "1/1/2021, 2/1...
Need Help
  • slorin's avatar
    slorin
    3 years ago

    Add [#"Month / Year"]<=Date  

     

    (Table,Date) => 
    List.Sum(Table.SelectRows(Table, each Date.Year([#"Month / Year"])=Date.Year(Date) and [#"Month / Year"]<=Date)[#"Energy - Total"])

     Stéphane

slorin's avatar
slorin
Super User
3 years ago

Add [#"Month / Year"]<=Date  

 

(Table,Date) => 
List.Sum(Table.SelectRows(Table, each Date.Year([#"Month / Year"])=Date.Year(Date) and [#"Month / Year"]<=Date)[#"Energy - Total"])

 Stéphane

  • patri0t82's avatar
    patri0t82
    Post Patron
    3 years ago

    You did it! That's amazing. Thanks very much.