1 ACCEPTED SOLUTION
Hi @sivaadityat
You can refer to the following solution.
1.Create a slicer table
Slicer = SUMMARIZE('Table',[Year],'Table'[Month])2.Create a measure
Measure =
VAR a =
DATE ( MAX ( 'Slicer'[Year] ), MAX ( 'Slicer'[Month] ), 1 )
VAR b =
EOMONTH ( a, -12 )
RETURN
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER (
'Table',
EOMONTH ( DATE ( MAX ( 'Table'[Year] ), MAX ( 'Table'[Month] ), 1 ), 0 ) >= b
&& EOMONTH ( DATE ( MAX ( 'Table'[Year] ), MAX ( 'Table'[Month] ), 1 ), 0 )
< EOMONTH ( a, 0 )
)
)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @sivaadityat
You can refer to the following solution.
1.Create a slicer table
Slicer = SUMMARIZE('Table',[Year],'Table'[Month])2.Create a measure
Measure =
VAR a =
DATE ( MAX ( 'Slicer'[Year] ), MAX ( 'Slicer'[Month] ), 1 )
VAR b =
EOMONTH ( a, -12 )
RETURN
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER (
'Table',
EOMONTH ( DATE ( MAX ( 'Table'[Year] ), MAX ( 'Table'[Month] ), 1 ), 0 ) >= b
&& EOMONTH ( DATE ( MAX ( 'Table'[Year] ), MAX ( 'Table'[Month] ), 1 ), 0 )
< EOMONTH ( a, 0 )
)
)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Your sample data is not usable.
You also need to define what you mean by "last 12 months" - does that include the currently selected month?
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
