Take Last Figure from Month

[CM_Mills]

Hello,

I have a set of data that takes a daily number. 

When viewing as a month or year i want to be able to see just the latest number and not the total. 

Is it possible to do this as a measure as this would worlk better for the rest of the databse if in the same table?

The table is called 'Data'

The value required is called 'Open Interest - Lots'

The Date is 'Date- Trade'

Thanks

[grazitti_sapna]

 Hi @CM_Mills 

You can try using:-

LatestNumber = CALCULATE( MAX('Data'[Open Interest - Lots]), FILTER( ALL('Data'), 'Data'[Date-Trade] = MAX('Data'[Date-Trade]) ) )

Thank You. Hope this will help you.