Forum Discussion

calebsg's avatar
calebsg
Frequent Visitor
10 years ago
Solved

MTD without measures (Direct Query)

Can you help me break out of my mental box? How would I have a MTD sales by sales rep without having a measures column?   When using the Import method I just add a measures column to the Sales R...
Need Help
  • pqian's avatar
    pqian
    10 years ago

    We are working on bringin measures to DirectQuery. Thank you for the patience :)

     

    Meanwhile, if your MTD value can be calculated with relational algebra (demands a certain kind of schema to do this), then you can go into the queries view and add a new query to the same database, use the custom query field to write SQL for the intented value. When this query fills, it'll stay in DirectQuery mode and act like a "measure"

pqian's avatar
pqian
Microsoft Employee
10 years ago

We are working on bringin measures to DirectQuery. Thank you for the patience :)

 

Meanwhile, if your MTD value can be calculated with relational algebra (demands a certain kind of schema to do this), then you can go into the queries view and add a new query to the same database, use the custom query field to write SQL for the intented value. When this query fills, it'll stay in DirectQuery mode and act like a "measure"

elliotdixon's avatar
elliotdixon
Responsive Resident
10 years ago

Thanks for the update pqian - looking forward to it.