Comparartive Analysis of Fy

sdhn — Thu, 01 Aug 2019 18:57:37 GMT

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

Re: Comparartive Analysis of Fy

sdhn — Thu, 01 Aug 2019 19:17:43 GMT

here is the DATABTABLE code

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

topic Comparartive Analysis of Fy in Developer

Comparartive Analysis of Fy

Re: Comparartive Analysis of Fy