Forum Discussion

BlueWhite3699's avatar
BlueWhite3699
Icon for Helper III rankHelper III
1 year ago
Solved

Measure take for ever to run

Hi Experts   the following measure retuns back the correct return - no issue there. But when applied to a 16million rows of data for one fiscal year its just take forever to return a value back in ...
Need Help
  • BlueWhite3699's avatar
    BlueWhite3699
    1 year ago
    YTD Forecast (full year) = 
CALCULATE (
    SUMX (
        ADDCOLUMNS (
            VALUES ( 'Date'[_MonthYearSort] ),
            "@TotalForecast", [Forecast]
        ),
        [@TotalForecast]
    ),
    DATESYTD ( 
        'Date'[Date],
        "31/03"
    ) 
)
BlueWhite3699's avatar
BlueWhite3699
Icon for Helper III rankHelper III
1 year ago

Hi - that formula is not going to work on 16million rows of data and based on the model. I have tried that and give the wrong answer

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

Hi BlueWhite3699 - can you please check the below logic:

 

 

 

YTD Forecast (full year)_1 =
VAR YTDForecast =
    CALCULATE(
        [Forecast], -- Use SUM directly for performance
        DATESYTD('Date'[Date], "31/03"),
        REMOVEFILTERS('Date')
    )
RETURN YTDForecast
  • BlueWhite3699's avatar
    BlueWhite3699
    Icon for Helper III rankHelper III
    1 year ago

    Hi Expert - its still incorrect look at my value for Mar 25 407839. thats the correct answer and kindly look at your value