How to setup a composite model

[rpinxt]

Had a directquery source and could not figure out how to make it mixed/composite

So I started new with an autocalendar, then added a direct query.

This apparently got me a mixed mode.

But why can I not make this relation??

The directquery has a date field and I thought to easily connected my date table with my directquery source.

What is going wrong? (yes I can it says circular dependency 😉 )

[rpinxt]

Ok so now the connection is there but it seems not to be working:

The yellow marks are different than normal.

I wanted to show the Quantity by period :

Nothing.

Quantity is the field Actual Qantity Delivered in the direct query source.

And period comes from the autocalendar en is setup like this :

dimDate =
ADDCOLUMNS(
CALENDARAUTO(),
"Period", FORMAT([Date], "MM-YYYY")

)

Is this just not possible with direct query or am I doing something still wrong??

[rpinxt]

Well how about this....

This works....but the other way around i get that circular dependency....🤔

[rpinxt]

@zenisekd 

It is setup from and CALENDARAUTO() :
dimDate =
ADDCOLUMNS(
CALENDARAUTO(),
"Year", YEAR([Date]),
"Quarter", FORMAT([Date],"\QQ"),
"Quarter Nr", QUARTER([Date]),

etc.

[zenisekd]

How did you get the dimDate? (what was your code)