Forum Discussion
Scenario to data modelling
Hello,
This is the data that I'm having.
| PO_DOC_NUMBER | Renewal Term | Next Renewal | Total Price | Total Price (USD) | MRC (USD) |
| 180200733 | 1 | 21/2/2023 | 1800 | 229.824 | 229.824 |
| 180200696 | 12 | 1/8/2023 | 14112 | 1801.82016 | 150.1517 |
| 180200716 | 24 | 4/1/2024 | 43200 | 5515.776 | 229.824 |
| 180105733 | 3 | 21/3/2023 | 1500 | 1584.585 | 528.195 |
| 180300874 | 36 | 1/6/2023 | 32400 | 32400 | 900 |
| 180105060 | 6 | 1/7/2023 | 7867.62 | 8311.275092 | 1385.213 |
| 180101992 | 60 | 27/2/2027 | 24000 | 25353.36 | 422.556 |
Each of this PO means the commitment that the company needs to pay to supplier.
For illustration purpose, the second data (180200696) means that the PO is going to be renewed on 21 Feb 2023, with 12 months of contract term in total value of USD 1801.82. So each month will be commitment of USD 150.15.
I need to display a column chart to show the monthly commitment of this PO. In this case, Feb 2023, Mar, Apr ... Jan 2024 i will have to pay my supplier USD 150.15 per month. Is there a way for me to display such data in column chart? How can i do so in Power BI?
1 Reply
The logic from getting from a renewal date of 1/8 to 21/2 is beyond me. I will assume it is correct but it's am lacking a formula.
Also it is beyond my knowledge how you can generate multiple dates (1 for each month) from 1 date using dax and then use this calculation in Power BI.
Instead i would create a table holding per contract per date the commitment
Then create you visual based on this new table
Good luck
