Comparartive Analysis of Fy

[sdhn]

Hi there,

One our former couslatnt helped us to create a report which compare oDD fiscal year.

Actually , First half of Fiscal Year started July 2018 to Dec 2018 and second half of Fiscal Year started  Jan 2019 to June 2019.  Thats report worked fine.

Now we need to compare Jan 2019 to June 2019 VS July 2019 to Dec 2019.

I did some stuff and reports is work fine.    We are gettig valuses for both 2019 fiscal years.  But somehow lables are showing as 2019 and 2020. 

Counsultant uses DAX programing.  

It was before in DATATABLE as:

       
                { 2016, "2015-06-28", "2016-07-02" },
                { 2017, "2016-07-03", "2017-07-01" },
                { 2018, "2017-07-02", "2018-06-30" },
                { 2019, "2018-07-01", "2019-06-29" }       

-------------------------------------------------------------------

Now I changed to:

{ 2016, "2016-01-03", "2016-12-31" }, 
 { 2017, "2017-01-01", "2017-12-30" }, 
{ 2018, "2017-12-31", "2018-12-29" },
 { 2019, "2018-12-30", "2019-12-29" } 

Calculation is working fine but somehow lables is displaying 2019 and 2020. Please see the attached snap shot.  

Now I am comparing 
 
First Half -- Jan 2019 to June 2019 VS

Second Half -- July 2019 to Dec 2019 
 
Please suggest me. Thanks

[sdhn]

here is the DATABTABLE code

https://drive.google.com/open?id=1W87_m-fvQJLXSvt9lNMalFE6q6zRtP7U