Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Mapping Data Tables

Hi-   Table 1 : I have a Data Table which gives me actuals by Posting Period (1,2,3....12), Product Category (A,B,C,D,E...), Reason Code (R1,R2..), Reason Category (C1, C2, C3), Date , company cod...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

Anonymous reason you will get this error is that the columns you are using in the crossfilter function are not used in the relationship for these tables. Make sure tables have an active relationship on the columns you are using in the crossfilter

 

✨ Follow us on LinkedIn

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi parry2k 

    Table 2 does not have the columns Posting Period (1,2,3....12), Reason Code (R1,R2..), Reason Category (C1, C2, C3), Date , company code ? So that is what I'm trying to figure out. How do I modify my Table 2 to have these columns included so that I can map it.