Forum Discussion

afeef's avatar
afeef
New Member
1 year ago
Solved

Current Year vs LY Comparison

Hi Community,   So currently I'm trying to display current Sales vs LY Sales in a clustered column chart. I have created a measure for LY:  NetSales LY = CALCULATE(sum('Current Sales'[NetSales])...
  • johnt75's avatar
    johnt75
    1 year ago

    You could try

    NetSales LY =
VAR _Dates =
    CALCULATETABLE (
        DATESYTD ( 'Calendar'[SalesDate] ),
        TREATAS ( { TODAY () }, 'Calendar'[SalesDate] )
    )
VAR Result =
    CALCULATE (
        SUM ( 'Current Sales'[NetSales] ),
        KEEPFILTERS ( SAMEPERIODLASTYEAR ( _Dates ) )
    )
RETURN
    Result
johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

You could try

NetSales LY =
VAR _Dates =
    CALCULATETABLE (
        DATESYTD ( 'Calendar'[SalesDate] ),
        TREATAS ( { TODAY () }, 'Calendar'[SalesDate] )
    )
VAR Result =
    CALCULATE (
        SUM ( 'Current Sales'[NetSales] ),
        KEEPFILTERS ( SAMEPERIODLASTYEAR ( _Dates ) )
    )
RETURN
    Result