Forum Discussion
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...
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"
calebsg currently the calculated measures and calculated columns are not supported in directquery mode. As a solution if you have not very large dataset then use import data mode otherwise SSAS tabular model will be an answer.