Forum Discussion
GA1993
Helper II
Helper IIAdd values per year
Hi, what is a manageable way to calculate or add a certain field/column/value of each year?? The below is an example data I have. I need to add all Training Travel (Plan) values for the year 2019 (h...
GA1993 , Few ways
Create a year column in table
year = year([Start Date]) // if text then try ->// left([Start Date],4)
then create a new table
Summarize(Table, Table[Year], "Total", Sum(Table[Training Travel Plan]))
amitchandak
Super User
Super UserGA1993 , Few ways
Create a year column in table
year = year([Start Date]) // if text then try ->// left([Start Date],4)
then create a new table
Summarize(Table, Table[Year], "Total", Sum(Table[Training Travel Plan]))