Suppose I have a field called FiscalMonthYearKey which looks like the following: 201901 201902 201903 201904 201905 201906 201907 201908 201909 201910 201911 201912 202001 202002...up to 202012 is there a way in dax to sum up revenue for the current fiscal month and the preceding 11 fiscal months? So 202011 would go back to 201912, 202010 would go back to 201911 and so on. I know this is easy with calendar dates but my organization really wants to look at fiscal periods.
@amitchandak to my knowledge, time intelligence works for calendar dates, not fiscal dates. Our fiscal months do not align with calendar months. For instance, february goes from Feb1 - Mar3. Thus I want to use the FiscalYearMonth keys to do so.
I have rolling 12m for calendar dates already done and that was easy.