Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Selecting Prior Date data in a table with Non Contiguous Dates

Hi,   I am used to working with Contiguous Dates. We have tables that contain snapshots of a point in time. The table contains the prior day close numbers and the prior month end numbers.    I ca...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous

    You could try to use PREVIOUSMONTH Function to add a measure like this

    pre amount = CALCULATE(SUM(Table1[AR_Amount]),PREVIOUSMONTH('Date'[Date]))

    Best Regards,

    Lin

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous

You could try to use PREVIOUSMONTH Function to add a measure like this

pre amount = CALCULATE(SUM(Table1[AR_Amount]),PREVIOUSMONTH('Date'[Date]))

Best Regards,

Lin