Forum Discussion
Solved
Incorrect Measure Totals
Hello. I am seeking assistance with Power BI desktop. The issue I am having is that the incorrect totals are being pulled from the raw data source. See below. The '24' at the top of th...
Hello VijayP,
I am unable to access the folder using my work laptop; however, using the following FY formula in my Dates Table, the issue appears to be resolved (so far):
FY =var _year = if(month([date]) >=4 , year([date]),year([date])-1)var _month = MONTH([Date])return ("FY "&_year&"-"&(_year+1))Thank you for all of your previous support!
Fiscal year formula ( A part of your date table)
if(monthnumber<4,monthnumber+9, monthnumber-3) it gives you the fiscal month
if(monthnumber<4,year-1,year+1 ) it gives you the right year as per fiscal calender
Rest I can help only when i can see the sample data
Hello VijayP,
I have included sample data for two fiscal years 2022-2023 and 2023-2024.
code date
AS 27-Oct-22 MS 28-Oct-22 JC 26-Oct-22 MS 3-Nov-22 JC 28-Oct-22 MA 11-Nov-22 JC 4-Nov-22 JC 3-Nov-22 HL 10-Nov-22 MS 9-Nov-22 JC 10-Nov-22 AS 9-Dec-22 JC 10-Nov-22 MS 21-Nov-22 JC 18-Nov-22 GS 18-Nov-22 HL 17-Nov-22 MS 24-Nov-22 MS 24-Nov-22 JC 2-Dec-22 JC 2-Dec-22 GS 2-Dec-22 MS 9-Dec-22 GS 9-Dec-22 HL 16-Dec-22 AS 16-Dec-22 MS 16-Dec-22 GS 9-Dec-22 GS 23-Dec-22 MS 20-Dec-22 GS 23-Dec-22 HL 5-Jan-23 AS 22-Dec-22 GS 13-Jan-23 AS 12-Jan-23 HL 12-Jan-23 AS 20-Jan-23 HL 20-Jan-23 AS 20-Jan-23 MS 19-Jan-23 MS 18-Jan-23 GS 20-Jan-23 AS 25-Jan-23 GS 14-Feb-23 HL 2-Feb-23 GS 19-Jan-23 MS 1-Feb-23 HL 1-Feb-23 MS 3-Feb-23 HL 3-Feb-23 PA 31-Jan-23 PA 2-Feb-23 MS 2-Feb-23 JC 3-Feb-23 MS 8-Feb-23 SR 10-Feb-23 GS 23-Feb-23 PA 15-Feb-23 JC 15-Feb-23 JC 17-Feb-23 PA 17-Feb-23 JC 15-Feb-23 JC 17-Feb-23 GS 24-Feb-23 PA 22-Feb-23 GS 24-Feb-23 JC 22-Feb-23 PA 23-Feb-23 SR 24-Feb-23 JC 3-Mar-23 GS 2-Mar-23 JC 1-Mar-23 SR 3-Mar-23 JC 2-Mar-23 JC 3-Mar-23 GS 10-Mar-23 GS 10-Mar-23 SR 17-Mar-23 JC 15-Mar-23 GS 22-Mar-23 SR 24-Mar-23 JC 24-Mar-23 GS 31-Mar-23 JC 28-Mar-23 GS 29-Mar-23 JC 29-Mar-23 SR 31-Mar-23 JC 30-Mar-23 HL 25-Apr-23 JC 5-Apr-23 SR 14-Apr-23 AU 14-Apr-23 AS 20-Apr-23 JC 14-Apr-23 JC 14-Apr-23 HL 26-Apr-23 AS 27-Apr-23 SR 27-Apr-23 AS 25-Apr-23 HL 12-May-23 AS 4-May-23 HL 19-May-23 AS 12-May-23 PA 5-May-23 JC 11-May-23 MS 12-May-23 HL 2-Jun-23 AS 19-May-23 SR 11-May-23 JC 17-May-23 AS 19-May-23 MS 19-May-23 SR 24-May-23 MS 2-Jun-23 JC 26-May-23 JC 26-May-23