Forum Discussion

Waxy's avatar
Waxy
Frequent Visitor
5 years ago

Determine available contracts

Hello   I have a Contract Assets table that the following  columns ; Contract_ID AssetName  StartDate_Copy - Contract's start date EndDate_Copy - Contract's end date I also have a Dates, dat...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Waxy not sure if it is a typo or you are actually using SUM, it should be MIN or MAX

 

Var ContractStart = SUM(ContractAssets[StartDate_Copy])
Var ContractEnd = Sum(ContractAssets[EndDate_Copy])
Waxy's avatar
Waxy
Frequent Visitor
5 years ago

Was having so much grief with this, starting to get confused how to reference a column in a table. StartDate_Copy and EndDate_Copy are the actual columns in the dataset table. Wasn't having much luck so tried to use variables to capture each row. Guess I'm off track?