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 Calendar Date table with one active relationship with Contract Active Date and another inactive one with Contract End Date, from Contract table.
For this visual, I need to use Contract End Date in the DAX formula.
And I'd like to use Month column from Calendar Date, for easier interaction with other visuals.
But it's not as expected.
When I'm using Month from Contract End Date, the visual is correct though.
This is the DAX I used. I'm not sure which one is wrong, and hope to get help.
Please provide sample data that covers your issue or question completely.
Please show the expected outcome based on the sample data you provided.
Thanks for the reminder.
Here's the data of source table.
|Customer||Annual Contract Value||Active Date||Contract Start Date||Contract End Date|
And the result expected in table view
|Month||Value of Contract Expected to be Ended|
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?
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?
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: