Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi I have a measure to calculate yearago data,but how can this be rewritten to handle leap year?
$YAgo:=CALCULATE(SUM(Metrics_Table[$]),DATEADD(Dates_Table[Anchor_Date],-364,DAY)) -- this is hardcoded formula how can this be dynamic to handle leap year?
Thanks..
$YAgo :=
CALCULATE(
SUM( Metrics_Table[$] ),
DATEADD( Dates_Table[Anchor_Date], -1, YEAR )
)
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
I already have that formula ,my question is how to handle leap year and made it dynamic?