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.
This is an example of my data and current output:
BoNummer is a unique key.
My current measure is this:
Time from creation to death in Years =
CALCULATE (
VAR TestamentCreationDate = MAX( FactArvesager[Testament creation date] )
VAR DeathDate = MAX( FactArvesager[Death of testament creator] )
RETURN
DATEDIFF( TestamentCreationDate , DeathDate , YEAR ),
USERELATIONSHIP(DimDato[DatoKey], FactArvesager[Date of start] )
)
As can be seen it works fine on row level, but I need to find the Average on the 'Date of start' = 53
I think I have complicated things in my head :.(
Plz help