cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Comparartive Analysis of Fy

 

 

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

SupportSS0801.PNG

1 REPLY 1
Helper I
Helper I

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.