Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to Solution.
Hi,
PBI file attached.
Hope this helps.
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.
And what result do you want. Explain and show that clearly. Your first post is not at all clear.
The result I want is when I select payment number 3 the table will display line #1, #2, and #3. Payment 3 was created on September 15 and lines #1-3 were created previous to that date however lines #4 and #5 were created after so I do not want to see them if I have payment 3 selected.
Currently if I select payment number 3 it will display only line #2.
Great thanks for the help!
You are welcome.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
102 | |
94 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |