Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
3 years ago

DAX INDEX Function Returns Null

Hi all, I'm working through this video tutorial from SQLBI on Window Functions - I'm at 16:52 in the video. I'm trying to get the base year sales to compare to all subsequent years, only that my ...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago

plse try this

DAX Studio:
 EVALUATE
SUMMARIZECOLUMNS (
    'Product'[BrandName],
    'Calendar'[Year],
    "Sales Amount",[Sales Amount],
    "Sales First Year",
        CALCULATE(
            [Sales Amount],
            INDEX(
                1, SUMMARIZE (ALLSELECTED('Product'),Product'[BrandName],'Calendar'[Year] ),
                ORDERBY( 'Calendar'[Year] )
            )
        )
    )