Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help with Calculating Previous Day Value using a Measure

Hello,    I am looking to create a measure that returns the value for a previous day, on any given selected date.    I have the following Measure but this returns the previous day from the last d...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

Try modifying your measure like below. 

Measure =
VAR lastRank = MAX ( 'V3 Measure for Changes'[rank] ) - 1
RETURN
    CALCULATE (
        [Total EOD Balance in GBP],
        FILTER (
            ALL ( 'V3 Measure for Changes' ),
            'V3 Measure for Changes'[rank] = lastRank
        )
    )

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.