Forum Discussion
How to setup a composite model
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 wh...
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??