Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calcualte Difference/% Change between two rows.

Hi there,   I have the following data:   Date  SPX Price    Volume 7/9/2020 3152.05 4829020000 7/8/2020 3169.94 4927700000 7/7/2020 3145.32 4563700000 7/6/2020 3179.72 473645...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    calerof , the correct version. Value replacement issue in my formula

    Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))

calerof's avatar
calerof
Icon for Impactful Individual rankImpactful Individual
6 years ago

amitchandak,

I have a problem with the last expression of the formula: "table[Date]", it doesn't fit, as the rest of the elemtents are calling the Date table and this last one is the date in the fact table.

F

 

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

calerof , the correct version. Value replacement issue in my formula

Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))

  • calerof's avatar
    calerof
    Icon for Impactful Individual rankImpactful Individual
    6 years ago

    amitchandak 

    Sorry, I checked it and didn't show the values on sparse dates, see: