Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |