Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

total issue with previous day

I calculate dayd over day. the measure returns correct values, but the total always 0 which is wrong, how to correct it ?

sales day over day = var _maxdate=CALCULATE(max('Date'[Date]), ALLSELECTED('Date'[Date]))
var _mindate=CALCULATE(min('Date'[Date]), ALLSELECTED('Date'[Date]))
var dates=filter(values('Date'[Date]), 'Date'[Date]<=_maxdate && 'Date'[Date]>=_mindate)
return if(ISEMPTY('Date'), BLANK()

, calculate(sum(Sales[Sales]), PREVIOUSDAY('Date'[Date]))+0)

I attach the pbix file https://1drv.ms/u/s!Amd7BXzYs7AVhBBCo_Ls7q5IkrXH?e=1ZQzsE

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , I tried this in your file 

    sales day over day = sumx(values('Date'[Date]), calculate(sum(Sales[Sales]), PREVIOUSDAY('Date'[Date])))

     

    You can try

    sales day over day = sumx(values('Date'[Date]), calculate(sum(Sales[Sales]), PREVIOUSDAY('Date'[Date])))+0

     

    find the file attached after signature

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , I tried this in your file 

    sales day over day = sumx(values('Date'[Date]), calculate(sum(Sales[Sales]), PREVIOUSDAY('Date'[Date])))

     

    You can try

    sales day over day = sumx(values('Date'[Date]), calculate(sum(Sales[Sales]), PREVIOUSDAY('Date'[Date])))+0

     

    find the file attached after signature