Forum Discussion
Row Count for Annualized (rolling) returns
Hi All, Thanks for all help for my queries till date. Please advise on the below Issue. I have a big data set for multiple portfolio's starting from year 2010 . i am calculating rolling returns...
Thanks amitchandak . wil try.
have a question: is there a way to check if data is avaialble for the full year before calculating this ?
CALCULATE(SUM ( Client_Returns_Data[Returns]))),DATESINPERIOD('Date Table'[_Date], [_Start_Date], -2,YEAR))
Hi amitchandak ,
Need a help,for one client i have both montlhy and daily data , Monthly data till <2021 and Daily Data from 2021
for Effective date 31/12/2022 , i need to check row count as below for each year and then calculate if rowcounts are satisifed... how to get this.. can u please check and help
| Year | Rowcount |
| 1 year- 2022 | 365 |
| 2 year 2022,2021 | 365+ 12 |
| 3 year 2022,2021,2020 | 365+ 12 +12 |