Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. 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 |
---|---|
17 | |
17 | |
15 | |
13 | |
12 |
User | Count |
---|---|
10 | |
8 | |
8 | |
7 | |
6 |