Forum Discussion

bchandl7's avatar
bchandl7
Frequent Visitor
9 years ago

YTD Measure not working properly

Hello,   I am very new to Microsoft BI, and I have a problem I am trying to solve. I have a measure that I have created to calulate sales amounts based off a fiscal year column:   FY15 Sales Amt ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi bchandl7,

 

Have you tried the formula below to see if it works? :smileyhappy:

FYTD15 Sales =
TOTALYTD (
    SUM ( 'Sales'[Sales Amt] ),
    dCalendar[Date],
    FILTER (
        ALL ( 'Sales' ),
        'Sales'[Fiscal_Year]
            = ( MAX ( 'Sales'[Fiscal_Year] ) - 2 )
    ),
    "6/30"
)

 

Regards