Forum Discussion

gclements's avatar
gclements
Icon for Helper II rankHelper 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
Icon for Most Valuable Professional rankMost 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
Icon for Helper II rankHelper 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.