Forum Discussion
akkitek
Helper III
Helper IIICreating a Matrix with a secondary relationship between tables
Hi everyone, I have 3 tables, Fin_data_by_month (fields: Month, total revenue, engagement division), revenue_targets (fields: month, engagement divison, monthly target) and one date table. I have cr...
Hi,
You may download my PBI file from here. You see a blank appearing in the Division field because the dim table of Divisions has been created only from the Target table (instead of getting created from both tables. I could not create it from both because i could not access the other table).
Hope this helps.
Ashish_Mathur - I know this is long ago but can you send me your PBI file pleas - I can't access it - Many thanks Hennie
- Ashish_Mathur
Super User
Hi,
I do not have that file now.