topic Return data from specified time interval in all rows in a calculated column in DAX Commands and Tips

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

souvik900766 — Fri, 09 Jul 2021 02:18:18 GMT

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 return year 2018 CY Value i.e. 754578 in 2018 Column in all rows.
The calculation should be based on latest month for e.g.
MAX(Month),dateadd(month,-3,year)
So, here I want to find from Jan, 2021, to 3 years prior data.
I tried with this three but not working..

Thanks in advance !

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

amitchandak — Fri, 09 Jul 2021 06:08:01 GMT

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])

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

souvik900766 — Fri, 09 Jul 2021 14:47:32 GMT

Hi amitchandak
Its not working...