YTD sum of columns in Power Query based on input from Excel

Hi Syndicate_Admin JeremyHillier ,

The basic structure of the YTD column calculation would be something like this:

if excelQuery[selectedMonth] = "JAN" then List.Sum({[Jan]})
else if excelQuery[selectedMonth] = "FEB" then List.Sum({[Jan], [Feb]})
else if...
...
else //your escape output here e.g. null, 0 etc.

This may be shortened if your excelQuery resolves in Power Query to just a value, rather than a table, to this:

if excelQuery = "JAN" then List.Sum({[Jan]})
else if excelQuery = "FEB" then List.Sum({[Jan], [Feb]})
else if...
...
else //your escape output here e.g. null, 0 etc.

Pete