Forum Discussion

Richard_Halsall's avatar
Richard_Halsall
Icon for Helper IV rankHelper IV
2 years ago
Solved

Matrix Visualisation to filter on 2 date values

Hi I need help with the following requirement   I have the data model as shown   Fact supply is at the contractor and date level and details a contractors availability and training course ...
  • lbendlin's avatar
    lbendlin
    2 years ago

     

    Active Training Dates = 
CALCULATE(
    DISTINCTCOUNT(FactSupply[Contractor__c]),
    TREATAS(values(TrainingDates[Date]),FactSupply[Training_Date__c])
    )

     

    I don't think I fully understand the premise - feel free to modify

     

     

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

 

Active Training Dates = 
CALCULATE(
    DISTINCTCOUNT(FactSupply[Contractor__c]),
    TREATAS(values(TrainingDates[Date]),FactSupply[Training_Date__c])
    )

 

I don't think I fully understand the premise - feel free to modify