Forum Discussion

gclements's avatar
gclements
Helper II
5 years ago

Max Date Name With Multiple Dates

Hi,   I am trying to get the Maximum Full Date Day Name from the Calandar table for the maximum Charge Date 1 within the Charge table.  However there are multiple dates so I guess I need to use Use...
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

How are the tables Calendar and Charge connected?

Can you post a screenshot of the relationship

  • gclements's avatar
    gclements
    Helper II
    5 years ago

    Hi,

     

    There are multiple date columns within the charge table which are connected to the Calandar table.  BillingPeriodFromDate is the active relationship for the purposes of most reporting.  Therefore the relationship between 'Charge'ChargeDate1 and 'Calandar'[Date] needs to be activated.

     

    Screenshot below.