Slow Changing Dimension Scenario, not working in DAX query, but working in MDX query

Question

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 ?

Answer 1

The queries that are sent by the Power View client to the model are issued as DAX statements, which you can monitor by setting a trace on the model.

Please try to simulate your query in Power View and grab the DAX statement from SQL Profiler

Hope it helps

Cheers,

Octoni