Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Problems in table relationships (value don't appear)

Problems in table relationships

I have two fact tables and two dimensions (date and accounting account), I have to make the relationship to integrate the information. One of the fact tables has the values ​​for 2021 because it is real data and the other fact table is for budget data, so they are for 2022.
When I make the relationship only between the date table, the separation is done by months, correctly.
When I make the relationship only by the ledger account, the separation is also made looking only at this parameter.
However, when I make the relationship between the two dimension tables, the date one unconfigures and the values ​​of the "fDespesas_Payments" table do not appear. When I break it down by month and year, by month it does the division, but when I put the year of "2022" there is no information, it comes values ​​only for "2021" which refers to the real data.
Could you help me please?

 

1 Reply

  • Hi! Anonymous 

     

    Can't comment without seeing the data. Please share your pbix file without PII data.