Forum Discussion
After Creating Relationship data is restricting
Hi,
I am facing the issue and cannot find any solution to it. I have three tables one is the date table having 18262 Rows, One is the Actual having 1768840 Rows and another is Budget Table Having 930020 rows. Now I have created a relationship between the Actual table and a date table and Budget Table. And use the user relationship function to create a budget link with a date table.
Now the real problem is my actual table has data to date and the budget has 12 months of data after creating these relationships my budget is showing only data to date aligned with actual.
Below is the screenshot attached.
Required data
| Jan | Feb | March | April | May | June | July | August | Sept | Oct | |
| Actual | 1 | 1 | 1 | 1 | 1 | |||||
| Budget | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Thank You.
1 Reply
Hi fahadraza ,
Not quite sure about your table structure and the relationship between the actual and expected tables, whether you can share your pbix file, and what output to expect, remember to delete confidential data
Best Regards
Lucien
