Forum Discussion
Return Values Before a Certain Date
Hello, I'm having some difficulties creating a visual that will show me some totals of line items from a contract. Some line items get added to a contract later on and I would like to be able to select a previous payment and only show the items that would have existed at that time of that payment.
The result I get in the top table only shows 1 line, the line that had an amount payable in payment 3, however I would like to show all lines that were created at the time of payment 3 (lines 1-4) since the payment date was Sep 15.
This is the measure I am using:
These are the realtionships in the table:
Thanks for any help.
Hi,
PBI file attached.
Hope this helps.
7 Replies
- Ashish_MathurSuper User
Hi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
- Yknoff1New Member
Hi Ashish, Here is a link to the pbix file Contract Data.pbix
- Ashish_MathurSuper User
And what result do you want. Explain and show that clearly. Your first post is not at all clear.