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 |