Forum Discussion

VVI's avatar
VVI
Frequent Visitor
3 years ago

Visual using USERELATIONSHIP

Hi all,   I'm trying to create a simple column chart as follow   with 2 tables: Calendar Date and Contract table. I have 2 date relationships between both tables, by using Date column in Ca...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

What is the importance of Contract Start Date?  Is it part of the issue?

 

how are you amortizing the annual contract value over the months?  Or is that not important?

 

Is this what you are looking for? 

 

 

VVI's avatar
VVI
Frequent Visitor
3 years ago

Hi lbendlin 

 

Contract Start Date is not the issue now, and there's no need to amortize contract over the year.

 

Is your visual using the period from Calendar Table?

  • VVI's avatar
    VVI
    Frequent Visitor
    3 years ago

    Hi lbendlin 

     

    As addition, I'd like to show the contract value for the year of current production year and moving forward. So, previous year, i.e. 2022 is not required.

    So, that's why I'm adding a filter:

     

    'Calendar Date'[Date]
                    >= _CurrentProdDate
    or
    Contract[Contract End Date]
                    >= _CurrentProdDate
     
    But both doesn't work.
    The later still shows 2022 value, which I don't need.
    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago


      Please show the expected outcome based on the sample data you provided.