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
Sales Prev Year =
CALCULATE(
    SUM( 'Chalgrove FactSalesOrderLine'[SaleValueBase] ),
    PREVIOUSYEAR( DimDate[FullDate] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    It is not failing now.. however it is not returning any values.

     

     

     

     

    • 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.