Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
User | Count |
---|---|
21 | |
14 | |
11 | |
8 | |
5 |
User | Count |
---|---|
24 | |
22 | |
20 | |
15 | |
10 |