Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Previous Year not working

Hi, I am running a previous year measure with    Sales Prev Year = CALCULATE(SUM('Chalgrove FactSalesOrderLine'[SaleValueBase]),PREVIOUSYEAR(DimDate[FullDate].[Year]))   However I am getting th...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago
    Sales Prev Year =
CALCULATE(
    SUM( 'Chalgrove FactSalesOrderLine'[SaleValueBase] ),
    PREVIOUSYEAR( DimDate[FullDate] )
)
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous ,

Check that DimDate[FullDate] is of Date type and try 

Sales Prev Year = CALCULATE(SUM('Chalgrove FactSalesOrderLine'[SaleValueBase]),PREVIOUSYEAR(DimDate[FullDate]))

See https://dax.guide/previousyear/ 

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.