Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

DAX Help required

Hi   I have a model with two tables.  My first Table = tenant table which has a Tenant number, property number and a tenant start date. The example below shows two different tenants living in one ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    cottrera Maybe:

    Tenant # Column =
  VAR __Property = [Property#
RETURN
  MAXX(FILTER('Tenant Table', [Property#] = __Property && [Repair logged date] >= [Tenancy start date] && [Repair logged date] <= [Tenancy end date]),[Tenant])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

cottrera Maybe:

Tenant # Column =
  VAR __Property = [Property#
RETURN
  MAXX(FILTER('Tenant Table', [Property#] = __Property && [Repair logged date] >= [Tenancy start date] && [Repair logged date] <= [Tenancy end date]),[Tenant])