Forum Discussion

EitanKGCS's avatar
EitanKGCS
Frequent Visitor
3 years ago
Solved

Measure not producing a column subtotal

Hi all,   I have a measure that pulls sales from the same period last year. I can't use SAMEPERIODLASTYEAR as the fact table is a non-standard date table (my fact table only has week-ending dates,...
@Dax Measure Error
  • amitchandak's avatar
    amitchandak
    3 years ago

    EitanKGCS , Try new measure like

    Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
    Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

     

    That should give a year behind total

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

EitanKGCS , Try new measure like

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

 

That should give a year behind total

EitanKGCS's avatar
EitanKGCS
Frequent Visitor
3 years ago

amitchandak thank you for the idea but it hasn't worked. 

 

I tried this: 

CALCULATE(SUM('All Companies'[@Profit]),dateadd('Dates'[Date],-1,Year))
 
But I got the following error:
 
Function 'DATEADD' expects a contiguous selection when the date column comes from a table on the 1-side of a bi-directional relationship.
 
Any suggestions on how to fix this error?