MTD without measures (Direct Query)

[calebsg]

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 Rep table getting the MTD total from the sales table. 

Now with Direct Query and Enterprise Gateway I can't get my head around how to accomplish the same thing.

[elliotdixon]

I agree with @HarrisMalik
I was planning on changing all my Power BI files over to be setup as Direct Query however without the ability to create measures there is no point. There is no point in using Power BI without the ability to setup measures.

Stick with the Import method and just wait for some more updates to the Enterprise Gateway to provide the data connection to more up to date information.
ED

[pqian · Accepted solution]

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]

Thanks for the update @pqian - looking forward to it.

[HarrisMalik]

@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.