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] )
)
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

No surprise; any measure evalutes in a comprehensive evaluation context. I helped correct syntactic error of DAX; analyse and author measures for desired results by yourself.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Lol thanks for the help.. at least its not failing now .. much appreciated.