Need help with a measure

[rmcgrath]

Hello.  I have two measures:  one measure returns the RecordPeriod (RecPD) from a slicer (only one period can be chosen).  The other measure extracts the year from that slicer value.  For example, say the user selects "202402" as the RecPd.  The Year Extract measure would return "2024".

How can I sum up a "Net" column of values depending on what the user chooses for the RecPD?  This is for a balance sheet and needs to be cumulative.  For example, using the above sample of 202402, the "Net" total would include "Net" values from 202400, 202401 and 202402.  Here is what I tried, but it did not work:

[amitchandak · Accepted solution]

@rmcgrath , Seem like [RecPd Selection] is measure. Use filter function

calculate(Sum(RawGLData[Net]), filter(dimDate, dimDate[Period] >= ([Year Extract] & 00) && dimDate[Period] <= [RecPd Selection] ))