Forum Discussion

souvik900766's avatar
souvik900766
Icon for Helper IV rankHelper IV
5 years ago

Return data from specified time interval in all rows in a calculated column

    Hi ! My Data:- Year Month  CY 2018 2019      Jan,19         784003.6       2020 Jan,20 796923   2021 Jan,21 912686.3   2018 Jan,18 754578.3   I want to...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

souvik900766 , Try like given examples

 

Example

sumx(filter(Table, Table[year] = 2018 ), [CY])

 

sumx(filter(Table, Table[year] = 2018 && [Month] = "Jan, 18" ), [CY])

 

if you can only month name like Jan, feb or 01, 02 etc

 

sumx(filter(Table, Table[year] = 2018 && [Month] = earlier([Month] )  ), [CY])