Forum Discussion
MrBIn
4 years agoFrequent Visitor
Problem using DateTable with two active related tables
Hello, I have two tables: "Budget" - contains information about budget of invests "IST" - contains information about actual used budget of these invests These two tables are related to each ot...
- 4 years ago
MrBIn , I would suggest to create one more bridge/common/diemension table
https://www.seerinteractive.com/blog/join-many-many-power-bi/
VIJAYKUMART
4 years agoResolver I
HI..
step1: Buchungsdatum (date column) in budget table should be connected to date table (1 to many)
step2 Buchungsdatum (date column) in IST table should be connected to date table ( 1 to many)
step 3 : delete the relation between budget and IST.
step 4 : make invest no. relation between budget and actual
i think helps ur time intelligence issue..