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
v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
1 year ago

Hello afeef,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.