Forum Discussion

Advocate I

10 years ago

Solved

Merging Date Fields

Hi, I have a fact table that contains multiple date fields: Created Date Quoted Date Instructed Date Completed Date I wish to have counts for each of these under one month heading in a...

Vvelarde
10 years ago
hi robcrockford

First create relatiosnhips between date columns and Date Table.

This should like this:

Next create measure to count for every date column:

Count-Created = CALCULATE(Count(Tabla1[Value]);Tabla1[Created Date])

Count-Quoted = CALCULATE(Count(Tabla1[Value]);USERELATIONSHIP(Calendario[Date];Tabla1[Quoted Date]))

Count-Instructed = CALCULATE(Count(Tabla1[Value]);USERELATIONSHIP(Calendario[Date];Tabla1[Instructed Date]))

Count-Completed = CALCULATE(Count(Tabla1[Value]);USERELATIONSHIP(Calendario[Date];Tabla1[Completed Date]))