Forum Discussion
Show an amount in future based on a value
I am working on a scenario where I am showing a Contract Amount in the month that the contract ends.
What I would like to do is show the monthly amount, (Contract Amount divided by 12) shown for the 12 months after the month that the contract ended. (For example, a $50,000 contract that ended in January 2023 will show the value of 4166.67 for each month between February 2023 to January 2024). I will have contracts expiring throughout the year so note the 12 month time period will differ for each contract.
I would like to have two tables, one that shows me the amount of the contract that expired (the white cells in my image) IF it has expired-which I have done in the image below.
But the second table will show the respective future 12 months (the green cells in my image based on those values in the white cells)
https://www.dropbox.com/s/1z85vpxa3ksk9wt/sample3.pbix?dl=0
Need a table with the green values, white cells are just to provide contextThis is showing my full amount of my contract when it has expired
To report on things that aren't there you need to use crossjoins and/or disconnected tables.
see attached