Generante two Fiscal year data ( Current Year and Previous year ) based on Current fiscal year.

[srisiva55]

I have one Requirement to use distinct Fiscal Year from Source Table and based on Source FY, want to generate New Table dynamically  like for ex: 2020-21 then needs to create 2019-20, 2020-21 etc just like below table. This table needs to generate dynammically . Can you please help me how to do this. Step by step instruction is helpful or pbix file also fine. 

[v-zhangti · Accepted solution]

Hi, @srisiva55 

You can try the following methods.

Table:

Table = UNION(SUMMARIZE(Source,Source[Source FY],"Index",1),SUMMARIZE(Source,Source[Source FY],"Index",2))

Last 2 Years = 
Var _minindex=CALCULATE(MIN('Table'[Index]),ALLEXCEPT('Table','Table'[Source FY]))
Return
IF([Index]=_minindex,LEFT([Source FY],4)-1&"-"&RIGHT([Source FY],2)-1,[Source FY])

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[srisiva55]

Thank You!!  This solution works for me