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] )
)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous ,Please mark this table as date tbale DimDate, also check data type of join column  in FactSalesOrder, that should also be date column

 

if not

Can you share a sample pbix after removing sensitive data.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak 

 

I am unable to make it a dat table as there is missing dates. our system puts defasult dates starting at 1900 so we need to have that in there along with the other info.

 

Thanks