Forum Discussion
[ Joining 2 Tables with specif layout ]
the solution maybe only work for this scenario. If we have more dates, e.g. 202402, then will not work. Let's see if anyone else can help you on this.
Super UserAnonymous
pls see the attachment below below
however, the question is how to get the data highlighted in yellow? could you pls elaborate more ?
ryan_mayu thks for the pbix file!!
Its almost there, but i cant loose the data in yellow in the merge/append process. I need the full outter join (which you did), but i cant loose the [month data] / [vision] data in the process. Those 2 columns need to be repeated.
[month data] contains near 700 [month bill acc] and every time i have a context existent in table 2 and no existent in table 1, i need to add that row for that [month bill acc] in table 1. The original table 1, have some years of [month data], each of them have repeated [month bill acc], and my difficult here is the sometimes table 2, has data not contained in table 1.
- ryan_mayu
pls provide the logic of getting the data. you must have different months in your real data. Then how can we know to display 202401 or 202402 or other month?
Hi ryan, i tried to make a better example. (i cant publish the excel right now because im working and it will be blocked).
The vision column (days) are a count related to [month bill acc] minus [month data], and if the difference is zero then 30d, if it is 1, then 60d, if its 2 months then 90d, and so on. To do that, we use a sequential yearmonth formula (year * 12 + month - 1).
[month data] will never be greater thand [month bill acc] in this model, but it can be lower.