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...
  • 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!