Forum Discussion

JJP1's avatar
JJP1
Regular Visitor
2 years ago
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...
Need Help
Show and Tell
  • JJP1's avatar
    JJP1
    2 years ago

    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!
VijayP's avatar
VijayP
Community Champion
2 years ago

JJP1 Without looking sample data it is difficult to assess the issue

  • JJP1's avatar
    JJP1
    Regular Visitor
    2 years ago

    Hello VijayP,

     

    On further investigation, I discovered the issue is with my dates table.

     

    Our fiscal year is April to Mar. The dates in January 2024 for some reason are not being accounted for when the 2023-2024 fiscal year filter is applied. For some reason they appear under the 2022-2023 fiscal year data.

     

    This is the fiscal year formula I used in the dates table:

     

    FY =
    var _year = if(month([date]) >=4 , year([date]),year([date])-1)
    var _month = MONTH([Date])
    return
    IF(
        _month=1,
        "FY "&(_year-1)&"-"&_year,
        "FY "&_year&"-"&(_year+1)
    )
     

    May you please help me identify the error? I am hoping to correct the formula in a way it will not require ongoing maintenance. 

     

    Thanks!