Por qué no me sirve una relación entre mi tabla calendario y otras con una conexion direct query?

[angieg02]

Hola Team!

Tengo conectada una data a otra herramienta a través de spark con una conexión Direct Query,  pero... a la hroa que quiero crear un modelo relacional con una tabla calendario y una tabla de kpi's no me funciona bien. No me deja crear medidas YTD, YoY y otros, me molesta mucho el filtro de fecha y cuando filtro por otras dimensiones también, me sale incorrecta la info. Alquien que me pudiera decir como hago para poder integrar varias datas a una conexión así?

[v-yiruan-msft]

Hi @angieg02 ,

There are multiple limitations when using DirectQuery, please check if your scenario hit any one of them...

DirectQuery limitations

And how to get YTD and YoY, you can refer the following links to get it.

Create Year-To-Date (YTD) measures in DAX (example uses Xero Invoices data and Power BI)

Custom Year-Over-Year Calculation in DAX

If the above one can't help you, please provide some raw data in your table (exclude sensitive data) with Text format, your visual Fields settings and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards