Calculate same period last year from timeframe slicer

[LachlanO]

Hi all,

I have one master graph which the data is populated based on the selected slicers.

I am trying to calculate actual enquiries recieved as well as for the same period last year (which this timeframe is specified via the Timeframe slicer). Ideally would like a measure which is dynamic so that the same period last year is calculated based on the filtered Timeframe selections.

Thanks.

[LachlanO · Accepted solution]

Believe I have solved it:
= VAR TimeframeSlicer = SELECTEDVALUE('Date Parameter (table)'[Parameter])

Return CALCULATE([Enquiries], SAMEPERIODLASTYEAR(table[EnquiryDate].[Date]))

[v-yiruan-msft]

Hi @LachlanO ,

It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours.  Thank you.

Best Regards