Forum Discussion
Cross-filtering not showing all data
Super User
Well, it looks like that, except I cannot make them both active. My budget table contains column "month" where the fields are simple text (jan, feb, mar...). And actual table, the one from SQL, is where I renamed a month formula derived from actual date (getting 1, 2, 3...) to the same string of months as I have in my bdg table... (jan, feb, mar...). So in the date table, I also put the same values (jan, feb, mar...) trying to connect these month columns... I probably made a mess with that one, but not sure how to do it differently.
- vojtechsima
Hi, Ismar
you can have Data Table that has columns that either have Month as Text or Month as Number.
You then map the tables accordingly, make sure you map Date Table with Your Excel table and SQL table, don't map SQL and Excel together.
Could you share please how your schema looks like, please?The thing is, I already have excel and SQL directly connected through some other field (category) as a many-to-many relationship. That might be the problem. When I try to make both active through date table, I get warned about ambiguity.
- vojtechsima
Can you share your model, please?