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

Hi afeef,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to johnt75 & rohit1991 for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.