Hi
I implement slow changing dimension scenario in my "Outlet" dimension on Tabular model. It will create new unique ID for every changes in outlet.
And I have 2 table NSR and TARGET, I want to query from both table but different period, NSR in daily level, and TARGET in monthly (all daily target will be sum into monthly target).
Relation between these table are:
NSR[Outlet_Seq_ID] = Outlet_Info[Outlet_Seq_ID]
Target[Outlet_Seq_ID] = Outlet_Info[Outlet_Seq_ID]

At first glance, the query return correct answer, but when their is changes in outlet level, the DAX query result become wrong (I cannot get "Monthly Target", it's return blank), But MDX query return correct answer.
So my question is, for querying tabular model, which language that I need to use ?
Is Power View and Power Pivot will be using DAX ?