Compare data with last month as same selected month

[RMtechm]

Hi All,

I need help on below issue which i am facing as i want to see data comparison in between selected month and same month for last year selected month using slicer. Here i can get selected month data but how to calculate last year data for selected month, as below..

Description	Actual	Actual
..	Jun-24	Jun-23
A	429.54	406.27
B	275.28	250.67
C	200.80	181.86
D	67.07	61.84
E	7.41	6.97

Thanks in Advance.

[dharmendars007 · Accepted solution]

Hello @RMtechm , 

Please try the below measure for "Actual Value" and "Actual Value Last Year"

Actual value = Actual Value = SUM('YourTable'[YourValueColumn])

Actual Value LY =
CALCULATE(
[Actual Value],
SAMEPERIODLASTYEAR('DateTable'[Date]))

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[RMtechm]

Hi @dharmendars007 ,

Thank you so much for the perfect solution this is what i exactly want 😊

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...